DB2 Version 9.7 for Linux, UNIX, and Windows

sequence_no_holding_lk - Sequence Number Holding Lock monitor element

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

Element identifier
sequence_no_holding_lk
Element type
information
Table 1. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Application appl Basic
Lock appl_lock_list Basic
Table 2. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Deadlocks event_dlconn -
Deadlocks with Details event_detailed_dlconn -
Usage
This identifier is used in tandem with appl_id to uniquely identify a transaction that is holding a lock on the object that this application is waiting to obtain.