Previous Topic: Group Buffer PoolNext Topic: Log Activity


Locks

These locking metrics are reported for each monitored DB2 Data Sharing Group:

Deadlocks

Displays the total number of times that an application on a member subsystem could not obtain a lock from the internal resource lock manager (IRLM) because of a deadlock during the last polling interval.

Escalations

Displays the total number of times that member subsystems successfully performed lock escalations on a table space during the last polling interval.

Global Requests

Displays the global number of lock requests that member subsystems made for physical locks (P-locks) during the last polling interval.

Global Suspensions

Displays total number of suspensions on member subsystems because of an IRLM global resource contention (conflicting IRLM lock states) during the last polling interval.

Local Requests

Displays the total number of times that a member subsystem requested a lock from IRLM on behalf of the application during the last polling interval.

Local Suspensions

Displays the total number of times that an application on a member subsystem was delayed in obtaining a lock from IRLM during the last polling interval. The requested resource was being held by another task with an incompatible lock.

Timeouts

Displays the total number of times that an application on a member subsystem could not obtain a lock from IRLM after waiting for a site-specified period during the last polling interval.