SQL summary—lock suspension activity
--- LOCK SUSPENSION ACTIVITY --------------------------------------------------------------------------
--------- SUSPEND REASON ---------- NORMAL RESUME TIMEOUT RESUME DEADLCK RESUME
TYPE LOCAL LATCH IRLMQ GROUP NOTIF OTHER COUNT AVGELAPS COUNT AVGELAPS COUNT AVGELAPS
----------- ----- ----- ----- ----- ----- ----- ----- -------- ----- -------- ----- --------
NORMAL LOCK 0 0 0 32 2 0 0 N/P 0 N/P 0 N/P
DRAIN 0 0 0 6 0 0 0 N/P 0 N/P 0 N/P
--------- SUSPEND REASON ---------- NORMAL RESUME TIMEOUT RESUME DEADLCK RESUME
TYPE LOCAL LATCH IRLMQ GROUP NOTIF OTHER COUNT AVGELAPS COUNT AVGELAPS COUNT AVGELAPS
----------- ----- ----- ----- ----- ----- ----- ----- -------- ----- -------- ----- --------
NORMAL LOCK 0 0 0 32 2 0 0 N/P 0 N/P 0 N/P
DRAIN 0 0 0 6 0 0 0 N/P 0 N/P 0 N/P
Following table describes the fields in the lock suspension activity section of the summary SQL report by PGM/PKG with workloads report.
Field | Description |
|---|---|
SUSPEND REASON: | |
LOCAL | Local resource contention |
LATCH | IRLMQ latch contention |
IRLMQ | IRLMQ queued request |
GROUP | Inter-system communication |
NOTIF | Inter-system message sending |
OTHER | Other lock suspends |
NORMAL RESUME: | |
COUNT | Count reason lock resumed=normal |
AVELAPS | Average normal lock resume elapsed |
TIMEOUT RESUME: | |
COUNT | Count reason lock resumed=timeout |
AVGELAPS | Average timeout lock resume elapsed |
DEADLCK RESUME: | |
COUNT | Count reason lock resumed=deadlock |
AVGELAPS | Average deadlock lock resume elapsed |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*