DB2 Server for VM: System Administration

Using the DBS Utility on non-DB2 Server for VM Application Servers

For a user to be able to use the DBS utility on a non-DB2 Server for VM DRDA target application server, you must first preprocess the DBS utility package on the target application server and then create the table SQLDBA.DBSOPTIONS on that application server. This is done by the DB2 Server for VM application requester. You must then obtain the necessary program bind and table creation privileges for your authorization-id on the target application server.

Note:

If the target application server does not support the ERROR option when preprocessing, you must create the DB2 Server for VSE & VM system catalog tables on the target application server for the preprocessing to work. The database managers that do not support the ERROR option (such as the common server database managers) generally supply a command file that creates the necessary table definitions. The command file to create the tables for the DBS Utility is typically called SQLDBSU.CMD or SQLDBSU.BAT.

To create the DBS Utility package, do the following from a DB2 Server for VM application requester:

1. To establish the non-DB2 Server for VM application server as the default application server, run the SQLINIT EXEC and specify the name of the non-DB2 Server for VM application server for the DBNAME parameter.
2. Link to the database machine's service disk:

     LINK machid 193 193 RR
   

3. Access the service disk:

     ACC 193 V
   

4. To preprocess the DBS utility, enter:

     SQLPREP ASM PP (PREP=SQLDBA.ARIDSQL,BLOCK,ISOL(CS),NOPR,ERROR,NOPU,
        CTOKEN(NO)) IN (ARIDSQLP MACRO V)
   

   Omit the ERROR option on the SQLPREP statement if the target application server does not support it.

5. If you ran a command file to create the table definitions necessary for preprocessing, the DBSOPTIONS table should have been created for you. If this table does not exists, enter the following DBS Utility commands:

     SET ERRORMODE CONTINUE;
    
     CREATE TABLE SQLDBA.DBSOPTIONS
      (SQLOPTION VARCHAR (18) NOT NULL,
       VALUE     VARCHAR (18) NOT NULL);
    
     CREATE UNIQUE INDEX SQLDBA.DBSINDEX
      ON SQLDBA.DBSOPTIONS (SQLOPTION,VALUE);
    
     INSERT INTO SQLDBA.DBSOPTIONS
      VALUES ('RELEASE','7.1.0');
    
     COMMIT WORK;
   

You must now obtain the necessary program bind and table creation privileges for your authorization-id on the target application server.