Lock Suspension Activity

This topic shows detailed information about Workload Detail - Lock Suspension Activity.

This block shows the lock suspension activity for each object performed by the event.

Lock Suspension Activity Workload Block Example

The field labels shown in the following sample layout of Lock Suspension Activity Workload Block are described in the following section. 

--- LOCK SUSPENSION ACTIVITY -------------------------------------------------------------------------------------------------
                                                ---------- SUSPEND REASON ---------- NORML  RESUME TIMEO  RESUME DEADL  RESUME
RESOURCE NAME                TYPE       REQUEST  LOCAL LATCH IRLMQ GROUP NOTIF OTHER COUNT     AET COUNT     AET COUNT     AET
MEMBER
DBPARALL            TSPARALL DATAPAGE   NOTIFY       0     0     0    24    24     0    24 0.74382     0     N/C     0     N/C
SE11
DBPARALL            TSPARALL DATAPAGE   LOCK         0     3     0     0     0     0     3 0.04096     0     N/C     0     N/C
SE11
DBPARALL            TSPARALL DATAPAGE   LOCK         0     5     0     0     0     0     5 0.06957     0     N/C     0     N/C
SE12
DBPARALL            TSPARALL DATAPAGE   UNLOCK       0     1     0     2     2     0     3 0.59058     0     N/C     0     N/C
SE21

The following list describes the fields in the lock suspension activity workload block:

RESOURCE NAME
The name of the resource on which the suspended request is made. The content of the field depends on the resource type:
  • The plan name for SKCT
  • The collection and package IDs for SKPT
  • The collection ID for COLLECT
  • The database name for DATABASE, CDB PLK, DBD PLCK
  • The buffer pool ID for ALTERBUF, GBP S/S, P/P PLCK, PAGEPLCK, GBP CAST, P/P CAST
  • The anchor point ID for HASH-ANC
  • The row ID for ROW
  • N/A for MASS, UTILITY, BINDLOCK, ALTERBUF, CATM MIG, CATM CAT, CATM DIR
  • The database and page set names for all others

The database and page set names are translations obtained from the IFCIDs 105 and 107. If these records are unavailable, the decimal DBIDs and OBIDs are printed.

MEMBER
The name of the Db2® member within the Db2 data sharing group.
TYPE
The type of the locked resource. Possible values are shown in Table 1.
REQUEST
The type of request that has been suspended:
LOCK
IRLM lock request
UNLOCK
IRLM unlock request
CHANGE
IRLM change request
QUERY
IRLM query request
NOTIFY
IRLM notify request
DRAIN
Drain request
LATCH
Latch request
SUSPEND REASON LOCAL
The number of suspensions due to local resource contentions.
SUSPEND REASON LATCH
The number of suspensions due to IRLM latch contentions.
SUSPEND REASON IRLMQ
The number of suspensions due to IRLM queued requests.
SUSPEND REASON GROUP
The number of suspensions due to global contention.
SUSPEND REASON NOTIFY
The number of suspensions due to intersystem message sending.
SUSPEND REASON OTHER
The number of suspensions due to reasons other than those listed previously.
Note: For drain suspensions, the suspension reason is always “waiting for the claim count to reach zero” and is categorized as OTHER.
NORML RESUME COUNT
The number of suspensions that ended in the task, resuming normal processing after the lock request has completed.
NORML RESUME AET
The normal resume average elapsed time. This is the normal resume elapsed time divided by the NORML RESUME COUNT.
TIMEO RESUME COUNT
The number of suspensions that ended in a timeout.
TIMEO RESUME AET
The average elapsed timeout time. This is the elapsed timeout time divided by the TIMEO RESUME COUNT.
DEADL RESUME COUNT
The number of suspensions that ended in a deadlock.
Note: Drain suspensions do not end in a deadlock.
DEADL RESUME AET
The average elapsed deadlock time. This is the elapsed deadlock time divided by the DEADL RESUME COUNT.