IBM Books

Agent ID Holding Lock


Snapshot Information Level
Application
 
Lock

API Structure(s)
sqlm_appl
sqlm_appl_lock
sqlm_lock_wait

Monitor Group
Lock
Lock
Lock

Resettable

No

 

API Element Name
Element Type

agent_id_holding_lock
information

 

Description:  The ID of the agent holding a lock for which this application is waiting. The lock monitor group must be turned on to obtain this information.

Usage:  This element can help you determine which applications are in contention for resources.

If this element is 0 (zero) and the application is waiting for a lock, this indicates that the lock is held by an indoubt transaction. You can use either "Application ID Holding Lock" or the command line processor LIST INDOUBT TRANSACTIONS command (which displays the application ID of the CICS agent that was processing the transaction when it became indoubt) to determine the indoubt transaction, and then either commit it or roll it back.

Note that more than one application can hold a shared lock on an object for which this application is waiting. See Lock Mode for information about the type of lock that the application holds. If you are taking an application snapshot, only one of the agent IDs holding a lock on the object will be returned. If you are taking a lock snapshot, all of the agent IDs holding a lock on the object will be identified.

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

[ DB2 List of Books | Search the DB2 Books ]