Lock Suspension Trace Example
This topic shows an example of a Lock Suspension trace.
Enter the following command to produce a Lock Suspension trace:
LOCKING
TRACE
LEVEL (SUSPENSION)
Lock Suspension trace example
This is a sample layout of a Lock Suspension trace.
LOCATION: OMPDA21 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: N/P LOCKING TRACE - SUSPENSION REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA21 ACTUAL FROM: 02/14/15 19:46:19.74
DB2 VERSION: V10 SCOPE: MEMBER PAGE DATE: 02/14/15
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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------
SKA java DRDA 19:46:19.74178259 LOCK SKPT DURATION=COMMIT STATE=S
SKA 'BLANK' 110214171010 SUSPEND ORIG.RSN=LOCAL CONTENTION
DISTSERV SERVER CTKN=5359534C564C3031 HASH =X'00003020'
REQLOC :::FFFF:9.152.122 COLL(HEX)= X'112233445566778899001122334455667788'
ENDUSER :OMPE Testuser PKID(HEX)= X'1122334455667788'
WSNAME :monroe
TRANSACT:BPMWorkload
LOCKING TRACE COMPLETE