DB2 Version 9.7 for Linux, UNIX, and Windows

appl_id_holding_lk - Application ID Holding Lock monitor element

The application ID of the application that is holding a lock on the object that this application is waiting to obtain.

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Deadlocks	event_dlconn	-
Deadlocks with Details	event_detailed_dlconn	-

Usage: This element can help you determine which applications are in contention for resources. Specifically, it can help you identify the application handle (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.
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.