Ensuring that users have access to CMS

Provide a new user with a VM logon ID. Set up the new users as you would a DB2 for VM user virtual machine. See DB2 Server for VM Database Administration for more information.

To communicate with DB2 for VM, a new QMF user logging on for the first time must issue this command (assuming the user is linked to the DB2 for VM production disk):

SQLINIT DBNAME(dbname)

where dbname is the name of the database that is being used for QMF. That command loads two required modules to the user's A-disk. As long as those modules remain, and as long as the user wants to use the same database, the command does not need to be reissued. Log on with the new user ID, and give the SOLINIT command for the new user.

If your users need to connect to DB2 for VM explicitly, grant them DB2 for VM CONNECT authority:

GRANT CONNECT TO userid IDENTIFIED BY password

The QMF CONNECT command enables an individual to access DB2 for VM using an established CONNECT ID (DB2 for VM user ID), or to connect to a different database during a QMF session. This command is useful for running jobs in batch mode.

After a user has received CONNECT authority (has been assigned a DB2 for VM user ID), the user can access DB2 for VM through the QMF CONNECT command:

CONNECT userid(PASSWORD=password

userid Any user ID conforming to the VM logon ID syntax rules is acceptable. However, only those IDs that have been granted access to DB2 for VM can be used in the CONNECT command. The ID can be embedded in double quotation marks.

DB2 for VM password The DB2 for VM password:

• Must have no more than eight characters.
• Can be embedded in single or double quotation marks. A single quotation mark embedded within single quotation marks is removed.
• Must contain no blanks (except for trailing blanks).

In order for a user to use the CONNECT command, the user ID and password must both be in SYSTEM.SYSUSERAUTH. The password does not need to be the same as the one associated with the VM logon ID.

In order for a user to use the CONNECT command, the user ID and password must both be in SYSTEM.SYSUSERAUTH. The password does not need to be the same as the one associated with the VM logon ID.

As a result of a QMF CONNECT command, the QMF profile resets to the password associated with the new DB2 for VM user ID or to the SYSTEM row default if that DB2 for VM user ID is not represented in Q.PROFILES. For more information about CONNECT authority, see theDB2 server for VM Database Administration manual.