Administration Guide

Creating a User Profile

Use the following procedure to create a user profile:

1. In the QueryAdministrator main window, select the User Administration tab.

2. Click Create User.

   A user profile window opens:
   
   

3. Enter a value in each of the fields listed in the table below:

4. Click OK after all values have been entered.
   

   Table 12. Fields to Define a User Profile
   

   Field	Description
   User ID	Provides the ID for the user or group. The user ID for the administrative user must be iwm.
   Type	Indicates whether the profile is for a user or a group.
   Cost Analysis	Provides a setting for cost analysis: Do Cost Analysis indicates that cost analysis is performed on all jobs for this user or group. Don't Do Cost Analysis indicates that the user can determine whether cost analysis is to be performed on specific jobs.
   Auth Level	Provides the authority level for the user or group: Not Allowed indicates that this user is not allowed to use DB2 Query Patroller. User indicates that this user has normal authority to submit queries and manage the status of those jobs in the DB2 Query Patroller system. Operator indicates that the user has operator authority. Administrator indicates that this user has administrative authority to alter the DB2 Query Patroller configuration as well as operator authority. The user ID for the administrative user must be iwm.
   Max Queries	Indicates the maximum number of the user's jobs that DB2 Query Patroller will run simultaneously. Max Queries must be an integer from 0 to 99.
   Low Priority	Provides the priority assigned to a job when the job is submitted on low priority. Low Priority must be an integer from 0 to 999.
   Normal Priority	Provides the priority assigned to a job when the job is submitted on normal priority. Normal Priority must be an integer from 0 to 999.
   High Priority	Provides the priority assigned to a job when the job is submitted on high priority. High Priority must be an integer from 0 to 999.
   User Threshold	Provides the threshold, which if exceeded by a job, causes the job to be placed on hold.
   Account ID	Provides a user-defined accounting ID that is written in the job accounting table
   Email Addr	Provides an address for notification when a job completes. If Email Addr is null, the user ID is used as the e-mail address.

[ DB2 List of Books | Search the DB2 Books ]