Example of a Lock Detail Trace

Edit online

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                       IBM Z OMEGAMON AI FOR DB2 (V6R1M0)                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: V13                                       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