DB2 Query Patroller Administration Guide

Node Administration

This chapter describes the procedures for listing nodes and changing node status.

Listing All Nodes

Use the following procedure to list all nodes:

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

2. Click List All Nodes. Each node is listed in tabular format on the Node Administration page.

Changing the Node Status

Use the following procedure to change the node status:

1. On the Node Administration page, select a node.

2. Click View / Edit.

   The Detailed Node Information window opens. (See the table below for a description of the fields in the Detailed Node Information window.)
   
   

3. Select the new status in the Requested Status field.

   Note:

   Requested Status is the only field in the Detailed Node Information window that can be changed; all other fields display values that have been supplied by DB2 Query Patroller.

4. Click OK.
   

   Table 13. Fields in the Detailed Node Information Window
   

   Field	Description
   Node ID	Provides the ID for the node.
   Current Status	Contains the current node status Active indicates that the node is able to run jobs. Inactive indicates that the node is not available to DB2 Query Patroller. Quiescing indicates that the node is in transition to the quiescent state. Running jobs will complete but no new jobs will be scheduled. Quiesced indicates that the node is quiescent. The node is available to DB2 Query Patroller but no new jobs are being scheduled.
   Requested Status	Indicates what the node status will be changed to: Active indicates that the node will be made active. Inactive indicates that the node will be made inactive. Running jobs will complete and no new jobs will be scheduled. Force indicates that the node will be made inactive immediately. Running jobs are terminated immediately and no new jobs will be scheduled. Quiesced indicates that the node will be made quiescent. Running jobs will complete.
   Date/Time Last Status	Indicates the date and time the status was last changed.
   Scheduled Jobs	Provides the number of jobs scheduled to run plus the number of jobs running on this node.
   CPU Utilization	Provides the CPU utilization of the node as a percentage (0 - 100). If CPU utilization information is not being collected, the value is -1.
   Disk Available	Indicates the bytes available in the file system where results are created. If disk utilization is not being monitored, the value is -1.
   Node Manager PID	Indicates the process ID of the node_mgr process.

[ DB2 List of Books | Search the DB2 Books ]