DB2 Help

Time Waited On Locks

Snapshot Level Database Application	Logical Data Grouping dbase appl appl_lock	Monitor Switch Lock Lock
Resettable	Yes
Event Type Database Connection Transaction	Logical Data Grouping db_event conn_event xaction_event
Element Name Element Type	lock_wait_time counter

Description: The total elapsed time waited for a lock.

Usage: At the database level, this is the total amount of elapsed time that all applications were waiting for a lock within this database.

At the application-connection and transaction levels, this is the total amount of elapsed time that this connection or transaction has waited for a lock to be granted to it.

This element may be used in conjunction with the "Lock Waits" monitor element to calculate the average wait time for a lock. This calculation can be performed at either the database or the application-connection level.

When using data elements providing elapsed times, you should consider:

Elapsed times are affected by system load, so the more processes you have running, the higher this elapsed time value.
To calculate this data element at the database level, the database system monitor sums the application-level times. This can result in double counting elapsed times at a database level, since more than one application process can be running at the same time.
To provide meaningful data, you can calculate the average wait time for a lock, as described above.