Locks

These locking metrics are reported for each monitored DB2 subsystem.

Deadlocks: Displays the number of times an application was unable to obtain a lock from the Lock Manager (IRLM) during the last polling interval because of a deadlock situation.
Escalations: Displays the number of times that DB2 successfully performed a lock escalation on a table space during the last polling interval.
Global Requests: Displays the global number of lock requests for physical locks (P-locks) during the last polling interval.
Global Suspensions: Displays the number of suspends occurring because of an IRLM global resource contention (IRLM lock states were in conflict) during the last polling interval.
Local Requests: Displays the number of times that DB2 sent a lock request to IRLM on behalf of the application during the last polling interval.
Local Suspensions: Displays the number of times that an application trying to obtain a lock from the lock manager (IRLM) was delayed during the last polling interval. These delays are due to the resource being held by another task with an incompatible lock.
Timeouts: Displays the number of times that an application was unable to obtain a lock from the lock manager (IRLM) due to timeout during the last polling interval.