Snapshot Information Level Application Lock |
API Structure(s) sqlm_appl sqlm_appl_lock sqlm_lock_wait |
Monitor Group Lock Lock Lock |
Resettable |
No |
|
Event Information Level Deadlock |
API Structure(s) sqlm_dlconn_event |
|
API Element Name Element Type |
appl_id_holding_lk information |
Description: The application ID of the application that is holding a lock on the object that this application is waiting to obtain.
Usage: This element can help you determine which applications are in contention for resources. Specifically, it can help you identify the agent ID and table ID that are holding the lock. Note that you may use the LIST APPLICATIONS command to obtain information to relate the application ID with an agent ID. However, it is a good idea to collect this type of information when you take the snapshot, as it could be unavailable if the application ends before you run the LIST APPLICATIONS command.
If you are using the database system monitor APIs, note that the API constant SQLM_APPLID_SZ is used to define the length of this element. Only the first 30 characters are currently used.
Note that more than one application can hold a shared lock on an object for which this application is waiting to obtain a lock. 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 application IDs holding a lock on the object will be returned. If you are taking a lock snapshot, all of the application IDs holding a lock on the object will be returned.
[ Top of Page | Table of Contents | Glossary | Index ]