This
flag is used to indicate that the subsection is blocked because
it is waiting to receive rows from any node.
- Element identifier
- tq_wait_for_any
- Element type
- information
Table 1. Snapshot Monitoring InformationSnapshot Level |
Logical Data Grouping |
Monitor Switch |
Application |
subsection |
Statement |
- Usage
- If ss_status indicates waiting
to receive data on
a table queue 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.