Notes

• When using CICS on OS/390 with a remote database server, all data at the server is restricted to read-only.
• Connecting to a database server resets the database authorization ID.
• The default database authorization ID for each server is system defined.

  (VSE only)

  To connect to a database server, the current database user must be defined at the remote database system. This is required even when the database user is specified on the CONNECT command.

• The database authorization ID at a DB2 for OS/390 server can be changed by running a QMF SQL Query with a SET CURRENT SQLID statement. For example:

    SET CURRENT SQLID = 'QMFADM'

  The QMF session is connected to a DB2 for OS/390 server when the global variable DSQAO_DB_MANAGER has the value of 2.

• (VSE only) Changing the database user will change the USER special register. The QMF session will operate with the privileges held by the newly established runtime authorization ID.

  This can be useful to perform privileged database administration tasks by changing the connection to a DBA userid.

• (VSE only) Your DB2 for VSE user password can be set or changed by running a QMF SQL Query with a GRANT SQL statement. For example:

  GRANT CONNECT TO &DSQAO_CONNECT_ID  
      IDENTIFIED BY password

• Differences between the CONNECT command and the DSQSDBNM program parameter:
  • The DSQSDBNM parameter establishes the initial database server used for the QMF session.
  • The CONNECT command changes the database server after a QMF session is established.
• The SQL CONNECT statement cannot be used in a QMF query.