DB2 Query Patroller Administration Guide

Job Queue Administration

This chapter describes the procedures for creating, editing, and removing job queues. This chapter is divided into the following sections:

• Viewing Job Queues.

• Creating a Job Queue.

• Editing a Job Queue.

• Removing a Job Queue.

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 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 New.

   An empty job queue information window opens. (See the table below for a description of the fields in the in the job queue information window.)
   
   

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

4. Click OK after the values have been entered.

Table 14. Caption

Description
Field	Description
Queue Id	Provides an ID for the job queue. This value must be unique.
Maximum Jobs	Maximum number of jobs allowed to run in the queue.
Data Source	The only data source supported is IWM. This field cannot be altered.
Maximum Cost	Indicates the maximum query cost that will be accpted 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 View / Edit. A detailed job queue window opens.

3. Edit the queue ID, the maximum jobs value, or the maximum cost value.

4. Click 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 Remove.

3. Click Yes to verify that you want to remove the selected job queue.

[ DB2 List of Books | Search the DB2 Books ]