IFCID 150 - Held Lock Data

This topic shows detailed information about Record Trace - IFCID 150 - Held Lock Data.

Record trace - IFCID 150 - Held Lock Data

The field labels shown in the following sample layout of Record Trace - IFCID 150 - Held Lock Data are described in the following section.


HELD LOCK DATA
LOCK REQUEST TOKEN : X'0C000002'       LOCK STATE  :  X'00'                    SUBSYSTEM NAME : SYS00003
ACE TOKEN          : X'00000BB9'       LOCK TYPE   :  P-LOCK                   FUNCTION       : LOCK
LOCK DURATION      : X'00'
QW0150RW: X'0C000002'                  QW0150UC: X'00000000'
QW0150SC: (1)     0  (2)     0  (3)     0  (4)     0  (5)     0  (6)     0  (7)     0  (8)     0

LOCK REQUEST TOKEN

The lock request token in hexadecimal.

Field Name: QW0150R3

LOCK STATE

The lock state.

Field Name: QW0150ST

SUBSYSTEM NAME

The name of the subsystem.

Field Name: QW0150N4

ACE TOKEN

The hexadecimal address of the agent control element indicating the holder of this lock.

Field Name: QW0150A3

LOCK TYPE

The type of lock.

Field Name: QW0150TL

FUNCTION

The lock function.

Field Name: QW0150F4

LOCK DURATION

The duration for which the lock is held:

MANUAL: Varies depending on the ISOLATION parameter
MANUAL+1: Temporary change of consistency level from CS to RR during bind and DDL
COMMIT: Until commit
COMMIT+1: Past commit; applies to locks needed to maintain the position for a cursor opened WITH HOLD
ALLOCATION: Until deallocation
PLAN: For the duration of the plan
FREE ALL LOCKS: Until all locks are freed

Field Name: QW0150D4