DB2 Version 9.7 for Linux, UNIX, and Windows

lock_wait_start_time - Lock wait start timestamp monitor element

The date and time that this application started waiting to obtain a lock on the object that is currently locked by another application.

Table 1. Table Function Monitoring Information
Table Function Monitor Element Collection Command and Level
MON_GET_APPL_LOCKWAIT table function - get information about locks for which an application is waiting Always collected
Table 2. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Application appl Lock, Timestamp
Lock lock_wait Lock, Timestamp
Table 3. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Locking - -
Deadlocks 1 event_dlconn Timestamp
Deadlocks with Details 1 event_detailed_dlconn Timestamp
1
This option has been deprecated. Its use is no longer recommended and might be removed in a future release. Use the CREATE EVENT MONITOR FOR LOCKING statement to monitor lock-related events, such as lock timeouts, lock waits, and deadlocks.

Usage

This element can help you determine the severity of resource contention.

Parent topic: Database system monitor elements
Related reference:
agent_id_holding_lock - Agent ID Holding Lock monitor element