- When using CICS on z/OS 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 UDB for z/OS 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 UDB for z/OS 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 Server 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.