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                      IBM OMEGAMON FOR DB2 PERFORMANCE EXPERT (V5R5M0)                  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