DB2 graphic  QMF Version 8

Determining which user profile to use

When QMF for Windows (QMF for WebSphere or QMF for Report Center) connects to a database server on behalf of a user, the user ID and password they provide are validated first by the database server. If the user information is valid, then QMF for Windows looks up the user ID in the user profile table, RDBI.PROFILE_TABLE.

The RDBI.PROFILE_TABLE is created when QMF for Windows is installed by copying the Q.PROFILE table. All user IDs that are included in the Q.PROFILE table at the time of installation, are included in the RDBI.PROFILE_TABLE.

Note:
After the initial copy of Q.PROFILE, any user ID added directly to Q.PROFILE is not automatically added to the RDBI.PROFILE_TABLE. You must add those new user IDs using QMF for Windows Administrator.

The RDBI.PROFILE_TABLE includes the following columns:

Table 27. Determining Resource Limits
CREATOR ENVIRONMENT TRANSLATION RESOURCE GROUP
userID WINDOWS English TECH
userID NULL English SALES
SYSTEM WINDOWS English BASIC
SYSTEM NULL English SYSTEM

When you create a new user profile, an entry is made in the table for the user ID that you enter. The Creator column is the user ID that you enter, the Environment and Translation fields are filled for you based on the environment and language of the system where QMF for Windows Administrator is installed. The Resource Group is the resource limits group to which this user is assigned.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004