DB2 REXX SQL for VM/ESA(R): Installation and Reference

Appendix K. Single User Mode Environment

To run DB2 RXSQL in single-user mode, you require SQLEXEC as an interface between DB2 Server for VM and the EXEC. When you start DB2 Server for VM in single user mode, DB2 Server for VM can only invoke modules. SQLEXEC provides the module interface and puts the user parameter list into standard format for invoking an EXEC. An untokenized parameter list is passed; therefore, the EXEC must be written in REXX. Tokenized parameter lists are used in EXEC1 and EXEC2 EXECs.

SQLEXEC must be in USERLIB LOADLIB for the DB2 Server for VM database start-up EXECs to find it. To create USERLIB or to add SQLEXEC to an existing USERLIB, type: 

     LKED SQLEXEC (LIBE USERLIB

To run an EXEC that uses DB2 RXSQL in single user mode, type: 

     SQLSTART DBNAME(dbname) [DCSSID(dcssid)]
     PARM(SYSMODE=S,[PARMID=parmid,]
     PROGNAME=SQLEXEC/[EXEC] execname execparms)

For more information on the SQLSTART EXEC, see the DB2 Server for VSE & VM Operation manual.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]