Release-Informationen

36.2 Changing the Node Status

The following is an update to the Node Administration section of the Query Patroller Administration Guide.

Use the following procedure to change the node status:

1. On the Node Administration page, select a node.
2. Click on View / Edit.

   The Detailed Information for Node window opens.

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

   Anmerkung:

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

4. Click on OK.

The following list provides information for each node parameter:

Node ID

Provides the ID for the node.

Node Status

Contains the current node status:

• Active indicates that the node is able to run jobs.
• Inactive indicates that the node's DB2 Query Patroller component is shut down. The node is not available to DB2 Query Patroller. To reactivate the node, use the iwm administrative user account to issue the dqpstart command.
• Quiescing indicates that the node is in transition to the quiescent state. Running jobs will complete, but no new jobs will be scheduled on the node.
• Quiesced indicates that the node is quiescent. The node is available to DB2 Query Patroller but no new jobs are being scheduled to that node.

Status Requested

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 node 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 manager process.