Locking Trace

Note: For an introduction to the Locking report set and general locking information refer to the Reporting User's Guide. It also provides information on input to locking.

The layout for locking traces is the same for each trace apart from the event-specific data. Layout of a Deadlock Trace shows the general layout of the locking trace and describes the common fields.

Layout of a Deadlock Trace

   LOCATION: XXXXXXXXXXXXXXXX          OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)                  PAGE: L-N
      GROUP: XXXXXXXX                                                                         REQUESTED FROM: MM/DD/YY HH:MM:SS.NN
     MEMBER: XXXXXXXX                              LOCKING TRACE - reporttype                             TO: MM/DD/YY HH:MM:SS.NN
  SUBSYSTEM: XXXX                                                                                ACTUAL FROM: MM/DD/YY HH:MM:SS.NN
DB2 VERSION: VN RN                                        SCOPE: MEMBER                            PAGE DATE: MM/DD/YY

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
------------------------------ ----------------- -------- --------- ----------------------- ----------------------------------------

XXXXXXXX XXXXXXXX XXXXXXXX     HH:MM:SS.NNNNNNNN XXXXXXXX XXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXX XXXXXXXX XXXXXXXXXXXX N/P               XXXXXXXXX          XXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXX XXXXXXXX                                                   XXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
REQLOC:  XXXXXXXXXXXXXXXX                                           XXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
                                                                    XXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
                                                                                            XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Field description

Here you find a description of all fields except for the trace header and the OMEGAMON for Db2® Performance Expert identifiers, for details of the trace header see The Locking Header of Reports and Traces. The descriptions start with the timestamp block and move to the right.
reporttype
This can be:
  • DEADLOCK
  • TIMEOUT
  • LOCKOUT
  • SUSPENSION
  • DETAIL
EVENT TIMESTAMP
The time at which the event occurred. The trace is sorted and printed in the order of this timestamp. The format of this timestamp is hh:mm:ss.nnnnnnnn.
RELATED TIMESTAMP
The timestamp of the suspended request that was selected as the victim of this event. This field only shows a value for suspension and detail traces. For other traces, this field always shows N/P because the related suspension event is not reported.
EVENT
The Locking event. This varies according to the type of trace.
LOCK RESOURCE TYPE
The type of locked resource. The values for the locked resource types are shown in Table 1.
LOCK RESOURCE NAME
The name of the resource. Each part of the lock resource name is printed on a separate line. The format of the name depends on the resource type as shown in Table 2.
EVENT SPECIFIC DATA
The layout and content of the event specific data varies according to the reported event and is described in the sections following.