Lock related statistics - fields (ISPF)

These statistics are displayed on the Lock Related Statistics panel.

Lock Deadlocks
The number of lock deadlocks.
Offload table name
CQM_SUMM_METRICS
Column name
LOCK_DEADLOCKS
Lock Suspensions
The number of suspensions due to locking conflicts.
Offload table name
CQM_SUMM_METRICS
Column name
LOCK_SUSPENSIONS
Lock Timeouts
The number of lock timeouts.
Offload table name
CQM_SUMM_METRICS
Column name
LOCK_TIMEOUTS
Latch Suspensions
The number of suspensions due to latch conflicts.
Offload table name
CQM_SUMM_METRICS
Column name
LATCH_SUSPENSIONS
Other Suspensions
The number of suspensions (aside from lock and latch suspensions).
Offload table name
CQM_SUMM_METRICS
Column name
OTHER_SUSPENSIONS
Lock Requests
The number of lock requests.
Offload table name
CQM_SUMM_METRICS
Column name
LOCK_REQUESTS
Unlock Requests
The number of unlock requests.
Offload table name
CQM_SUMM_METRICS
Column name
UNLOCK_REQUESTS
Query Requests
The number of query requests.
Offload table name
CQM_SUMM_METRICS
Column name
QUERY_REQUESTS
Change Requests
The number of change requests.
Offload table name
CQM_SUMM_METRICS
Column name
CHANGE_REQUESTS
Other Requests
The number of all other requests.
Offload table name
CQM_SUMM_METRICS
Column name
OTHER_REQUESTS
Claim Requests
The number of claim requests.
Offload table name
CQM_SUMM_METRICS
Column name
CLAIM_REQUESTS
Claim Failures
The number of unsuccessful claim requests.
Offload table name
CQM_SUMM_METRICS
Column name
CLAIM_FAILED
Drain Requests
The number of drain requests.
Offload table name
CQM_SUMM_METRICS
Column name
DRAIN_REQUESTS
Drain Failures
The number of unsuccessful drain requests.
Offload table name
CQM_SUMM_METRICS
Column name
DRAIN_FAILED
XES Lock Requests
The number of XES lock requests.
Offload table name
CQM_SUMM_METRICS
Column name
XES_LOCK_REQUESTS
XES Change Requests
The number of XES change requests.
Offload table name
CQM_SUMM_METRICS
Column name
XES_CHG_REQUESTS
XES Unlock Requests
The number of XES unlock requests.
Offload table name
CQM_SUMM_METRICS
Column name
XES_UNLK_REQUESTS
IRLM Global Resource Contention
The accumulated wait time due to global contention for parent L-locks.
Offload table name
CQM_SUMM_METRICS
Column name
IRLM_GLOBAL_CONT
XES Global Resource Contention
The accumulated wait time due to XES global contention for parent L-locks.
Offload table name
CQM_SUMM_METRICS
Column name
XES_GLOBAL_CONT
False Resource Contention
The accumulated wait time due to false resource consumption.
Offload table name
CQM_SUMM_METRICS
Column name
FALSE_RES_CONT
Incompatible Retain Lock
The accumulated wait time due to incompatible retain locks.
Offload table name
CQM_SUMM_METRICS
Column name
INCOMPAT_RET_LOCK
Shared Lock Escalations
The number of lock escalations to shared mode.
Offload table name
CQM_SUMM_METRICS
Column name
SHARED_LOCK_ESC
Exclusive Lock Escalations
The number of lock escalations to exclusive mode.
Offload table name
CQM_SUMM_METRICS
Column name
EXCL_LOCK_ESC
Lock Requests - PLOCKS
The accumulated wait time due to parent object locks (database, table space, table, partition).
Offload table name
CQM_SUMM_METRICS
Column name
LOCK_REQ_PLOCKS
Change Requests - PLOCKS
The number of change requests for parent locks.
Offload table name
CQM_SUMM_METRICS
Column name
CHANGE_REQ_PLOCKS
Unlock Requests - PLOCKS
The number of unlock requests for parent locks.
Offload table name
CQM_SUMM_METRICS
Column name
UNLOCK_REQ_PLOCKS