Example of a Lock Detail Trace
This topic shows an example of a Lock Detail trace.
Lock Detail trace example shows a sample Lock Detail trace, produced by the following command:
LOCKING
TRACE
LEVEL (DETAIL)
Lock Detail trace example
This is the sample layout of a Lock Detail trace.
LOCATION: OMPDA21 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: N/P LOCKING TRACE - DETAIL REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA21 ACTUAL FROM: 02/14/16 19:45:51.41
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 02/14/16
PRIMAUTH 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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
19:45:53.99629213 LOCK SKPT DURATION=COMMIT STATE=S
REQUEST RSN CODE= 0 RTNCD= 0
CTKN=18B61ACB02FABE19 HASH =X'00003280'
COLL(HEX)= X'112233445566778899001122334455667788'
PKID(HEX)= X'1122334455667788'
LOCKING TRACE COMPLETE