DB2 Server for VSE: System Administration

Using ISQL on non-DB2 Server for VM Application Servers

For a user to be able to make ISQL requests against a remote application server, you must create the ISQL package on the remote application server. You can use the DBS Utility RELOAD PACKAGE command or the CBND utility to do this.

Job ARIS120D can be used to create the ISQL package using the DBS Utility.

To load the ISQL package using the CBND utility, do the following:

• Store the ISQL bind file, which was initially shipped as an 80-byte A-type source member (ARISIQBD), in the "DB2.BIND.MASTER" bind file. For more information on storing the ISQL bind file in the "DB2.BIND.MASTER" bind file, see the DB2 Server for VSE Program Directory.
• Execute CBND, specifying the package name SQLDBA.ARIISQL, against the target application server. For more information on the CBND command, see the DB2 Server for VSE & VM Application Programming manual. If the target application server does not support the ERROR option, it should supply a command file named ISQL.CMD or ISQL.BAT, which creates the tables that must exist in order to create the ISQL package.
• Create the table SQLDBA.ROUTINE, and any other userid.ROUTINE tables that you want.