DB2 Server for VM: System Administration

Using ISQL on non-DB2 Server for VM Application Servers

For a user to be able to make ISQL requests against a non-DB2 Server for VM application server, you must load the ISQL package on that application server.

Before you can load ISQL on a non-DB2 Server for VM application server, you must first preprocess the DBS utility on the non-DB2 Server for VM application server. When the DBS utility is preprocessed on the non-DB2 Server for VM application server, ensure that you have the necessary program bind and table creation privileges for your authorization-id on the target application server.

If the target application server does not support the ERROR option, run the ISQL.CMD or ISQL.BAT file. This file is supplied by the target server.

Do the following from a DB2 Server for VM application requester to load ISQL:

1. Run the SQLINIT EXEC to establish the non-DB2 Server for VM application server as the default application server.
2. To link to the database machine's service disk, enter:

     LINK machid 193 193 RR
   

3. To access the service disk, enter:

     ACC 193 V
   

4. Issue the following CMS command:

     FILEDEF ARIISQLM DISK ARIISQLM MACRO V
   

5. Issue the following DBS utility command to reload ISQL:

     RELOAD PACKAGE (SQLDBA.ARIISQL) REPLACE KEEP INFILE (ARIISQLM);
   

6. Create the table SQLDBA.ROUTINE, and any other userid.ROUTINE tables that you want.

   For the CREATE TABLE statement that you use to create SQLDBA.ROUTINE, see the DB2 Server for VSE & VM Interactive SQL Guide and Reference manual.