DB2 Query Patroller Administration Guide

User Administration

This chapter describes the procedures for creating, editing, and removing user profiles. All users submitting queries through the DB2 Query Patroller system must have a user profile.

Listing User Profiles

Use the following procedure to list all user profiles:

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

2. Click List All Users to list all user profiles.

   Each user profile is listed in a table on the User Administration page.

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.

Editing a User Profile

Use the following procedure to edit a user profile:

1. On the User Administration page, select a user profile.

2. Click View / Edit. The Detailed User Profile window opens.

3. Edit each field that you wish to change. See Table 12 for a description of each field.

   Note:

   Once a user profile has been created, you cannot change the User ID and Type.

4. Click OK after all new values have been entered.

Removing a User Profile

Use the following procedure to remove a user profile:

1. On the User Administration page, select a user profile.

2. Click Remove.

3. Click Yes to verify that you want to remove the selected user profile.

   Note:

   User iwm cannot be deleted.

[ DB2 List of Books | Search the DB2 Books ]