IBM Books

Waited for Node on a Tablequeue


Snapshot Information Level
Application

API Structure(s)
sqlm_subsection

Monitor Group
Statement

Resettable

No

 

API Element Name
Element Type

tq_node_waited_for
information

 

Description:  If the subsection status "Subsection Status" is waiting to receive or waiting to send and "Waiting for Any Node to Send on a Tablequeue" is FALSE, then this is the number of the node that this agent is waiting for.

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.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]