Field

Description

Lock List

Size

Database locks are managed in a list. This parameter determines the maximum length of the list (database configuration parameter LOCKLIST). The lock list is allocated dynamically.

In Use

Current size of the lock list

Lock Waits

Total

Total number of times that applications or connections waited for locks

Time Waited

Total amount of elapsed time in milliseconds that applications waited for a lock to be granted

Average Time Waited

Average time in milliseconds waited for a lock

Escalations

Lock Escalations

Number of times that locks have been escalated from several row locks to a table lock.
If the maximum allowed length of the lock list is reached, row locks are converted to table locks to save space in the lock list. This process is called “lock escalation“.

Exclusive Lock Escalations

Number of times that locks have been escalated from several row locks to one exclusive table lock, or the number of times an exclusive lock on a row caused the table lock to become an exclusive lock.
Exclusive locks are important to track since they can impact the concurrency of your data because other applications cannot access data held by an exclusive lock.

Locks

Locks Currently Held

Total number of locks currently held by the applications

Deadlocks Detected

Number of deadlocks that have occurred. Deadlock situations are recognized and resolved automatically by the database.
The database configuration parameter DLCHKTIME determines when a lock wait situation is resolved.

Lock Timeouts

Number of times that a request to lock an object timed out instead of being granted. Parameter LOCKTIMEOUT determines when a lock wait situation is resolved.