DB2 Query Patroller Administration Guide

System Administration

This chapter describes the procedures for listing and editing system parameters.

Listing System Parameters

Use the following procedure to list the system parameters:

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

2. Click List System Administration to list the system parameters.

Editing System Parameters

Use the following procedure to edit system parameters:

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

2. Click List System Administration to list the system parameters.

3. Click View / Edit.

   The Detailed System Information window opens:
   
   

4. Enter a value in each of the fields listed in the following table:

5. Click OK after all values have been entered.
   

   Table 16. System Parameters
   

   Field	Description
   Cost Threshold	If the total estimated cost of all running queries is greater than the cost threshold, no more queries will be scheduled to run on any node.
   Query Threshold	If the total count of running queries is greater than the query threshold, no more queries will be scheduled to run on any node.
   Accounting Status	Indicates whether information is written to the job accounting table for use by Tracker utility. Write to Table indicates that accounting is on; Do Not Write to Table indicates that accounting is off.
   Days to Keep Job	Indicates the number of days to retain an entry in the job table after the job completes. Use 0 to retain job entries indefinitely.
   Days to Keep Results	Indicates the number of days to retain result sets after the job completes. Use 0 to retain result sets indefinitely.
   CPU Threshold	This field is not used. The Node CPU Max field on the Data Source Administration page defines the CPU threshold for each node.

[ DB2 List of Books | Search the DB2 Books ]