Lockout Trace
The lockout trace contains details of timeout and deadlock events.
You generate it by using the following command:
LOCKING
TRACE
LEVEL (LOCKOUT)
For information on the layout of a lockout trace, refer to Deadlock Trace and Timeout Trace.
Lockout Trace
Here is an example of a lockout trace.LOCATION: STLEC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: DSNCAT LOCKING TRACE - LOCKOUT REQUESTED FROM: NOT SPECIFIED
MEMBER: DB2A TO: NOT SPECIFIED
SUBSYSTEM: DB2A ACTUAL FROM: 01/20/21 11:55:42.73
DB2 VERSION: V12 SCOPE: MEMBER PAGE DATE: 01/20/21
0PRIMAUTH CORRNAME CONNTYPE
ORIGAUTH CORRNMBR INSTANCE EVENT TIMESTAMP --- L O C K R E S O U R C E ---
PLANNAME CONNECT RELATED TIMESTAMP EVENT TYPE NAME EVENT SPECIFIC DATA
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SYSADM SFCRIX5E TSO 11:55:42.73818275 TIMEOUT SKPT COLL/PKID=X'42415254434F4C310000000000000050524F4739'
DM 'BLANK' D9263E6C612C N/P CTKN=1B24C58A0034567B
DSNTEP3 BATCH REQUEST =LOCK UNCONDITIONAL
ENDUSER :SYSADM STATE =X ZPARM INTERVAL= 60
WSNAME :BATCH DURATION=COMMIT INTERV.COUNTER= 1
TRANSACT:SFCRIX5E HASH =X'00001620'
STMTINFO=DYNAMIC
STMTID =X'0000000000000001'
------------ HOLDERS/WAITERS -----------
HOLDER
LUW=USIBMSY.SYEC1DB2.D9263E66EB70
MEMBER =DB2A CONNECT =BATCH
PLANNAME=BARTPRG9 CORRID =SF00005C
DURATION=ALLOCATN PRIMAUTH=SYSADM
STATE =S STMTINFO=N/P
ENDUSER =SYSADM
WSNAME =BATCH
TRANSAC=SF00005C
STMTID =X'0000000000000000'