Snapshot Level Application |
Logical Data Grouping subsection |
Monitor Switch Statement |
Resettable |
No |
|
Element Name Element Type |
tq_wait_for_any information |
Description: This flag is used to indicate that the subsection is blocked because it is waiting to receive rows from any node.
Usage: If "Subsection Status" indicates waiting to receive data on a tablequeue and this flag is TRUE, then the subsection is waiting to receive rows from any node. This generally indicates that the SQL statement has not processed to the point it can pass data to the waiting agent. For example, the writing agent may be performing a sort and will not write rows until the sort has completed. From the db2expln output, determine the subsection number associated with the tablequeue that the agent is waiting to receive rows from. You can then examine the status of that subsection by taking a snapshot on each node where it is executing.