DB2 Version 9.7 for Linux, UNIX, and Windows

tq_node_waited_for - Waited for node on a table queue monitor element

If the subsection status ss_status is waiting to receive or waiting to send and tq_wait_for_any is FALSE, then this is the number of the node that this agent is waiting for.

Element identifier
tq_node_waited_for
Element type
information
Table 1. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Application subsection Statement
Usage
This can be used for troubleshooting. You may want to take an application snapshot on the node that the subsection is waiting for. For example, the application could be in a lock wait on that node.