Release Notes

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

   |Note:

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