Differences Between the DB2 and DB2 for VM Data Adapters

There are some minor differences between the DB2 and DB2 for VM Data Adapters as a result of their operating environments. The following list outlines these differences:

• To use the DB2 Data Adapter, you must have access to partitioned data sets allocated to the following DDNAMEs: MASTER, FOCSQL, and FOCEXEC. Your DBA must authorize you to execute the FOCUS PLAN used at your site.
• AUTODB2 is the procedure that automatically generates the Master and Access Files in the DB2 Data Adapter. The DB2 for VM Data Adapter uses AUTOSQL.
• EXPDB2 (or EXPDB231) is the procedure that runs the FOCUS EXPLAIN utility in the DB2 Data Adapter. The DB2 for VM Data Adapter uses EXPSQL (or EXPSQL34). See The Data Adapter Optimizer, for information about the FOCUS EXPLAIN utility.
• The AUTODB2 procedure uses the system catalog tables SYSCOLUMNS, SYSINDEXES, SYSKEYS, and SYSTABLES. AUTOSQL uses SYSCOLUMNS and SYSINDEXES.
• The AUTODB2 procedure requires the following allocations:
• AUTODB2 must be a member in the FOCEXEC PDS.
• DB2CAT, DB2SYSTB, and AUTODB2 must be members in the MASTER PDS.
• DB2CAT and DB2SYSTB must be members in the FOCSQL PDS.

• SYSIBM is the creator of all system catalog tables in a DB2 environment. The DB2 for VM environment uses SYSTEM.
• The DBSPACE default for DB2 tables is database DSNDB04. For DB2 for VM the default is the user's private dbspace.
• The default isolation level for static MODIFY procedures in DB2 for VM is CS. To invoke the Repeatable Read isolation level (RR), the MODIFY itself must contain an SQL SET ISOLATION RR command.

In DB2, the default isolation level for static MODIFY procedures is RR. To change this default, you must leave the FOCUS environment and issue a separate DB2 BIND with an isolation level of CS. Consult the IBM DB2 Command and Utility Reference for additional information on the BIND command.

• The DB2 CURRENT SQLID security facility is not available in DB2 for VM.
• The DB2 for VM CONNECT security facility is not available in DB2 on MVS.