IBM DB2 Query Patroller Administration Guide

Job Queue Administration

This section describes the procedures for creating, editing, and removing job queues.

Viewing Job Queues

Use the following procedure to view the job queues:

1. In the QueryAdministrator main window, select the Job Queues tab.
2. Click on View / Edit to list the system job queues. Each job queue is listed in tabular format on the Job Queues page.

Creating a Job Queue

Use the following procedure to create a job queue:

1. In the QueryAdministrator main window, select the Job Queues tab.
2. Click on New.
3. Enter a value in each of the fields listed in the table below.
4. Click on OK after the values have been entered.

   An empty job queue information window opens.
   
   

The following list provides information for each job queue parameter:

Queue Id

Provides an ID for the job queue. This value must be unique.

Data Source

The only data source supported is IWM. This field cannot be altered.

Maximum Jobs

Maximum number of jobs allowed to run in the queue.

Maximum Cost

Indicates the maximum query cost that will be accepted by the job queue. DB2 Query Patroller assigns jobs to the queue that has the smallest cost limit that is not less than the cost of the job.

Editing a Job Queue

Use the following procedure to edit a job queue:

1. On the Job Queues page, select a job queue.
2. Click on View / Edit. A detailed job queue window opens.
3. Edit the queue ID, the maximum jobs value, or the maximum cost value.
4. Click on OK.

Removing a Job Queue

Use the following procedure to remove a job queue:

1. On the Job Queues page, select the job queue you want to remove.
2. Click on Remove.
3. Click on Yes to verify that you want to remove the selected job queue.