Lock Suspension Events - Lock, Unlock, Change, and Notify Suspend
This topic shows the format of data specific to Lock, Unlock, Change, and Notify Suspend for Lock Suspension events. It also describes the fields provided for this event.
Format of data specific to Lock, Unlock, Change, and Notify Suspend
This is the sample format for data specific to Lock, Unlock, Change, and Notify Suspend.
DURATION=xxxxxxxx STATE=xxxxx XES PROP=x ORIG.RSN=xxxxx xxxxxxxxxx XES FORC=x aaaaaaaaaaaaaaaaaaaaa XES ASYN=x PARENT =xxxxxxxx HASH =X'hhhhhhhh'
Field description
- DURATION
- The length of time the lock is held. Valid values are shown in Table 1.
Table 1. Lock Duration - IRLM SUSPEND Duration Description INTEREST Duration of P-Locks 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 ALLOCATN Until deallocation PLAN For the duration of the plan UTILITY For the duration of the utility execution FREE ALL Until all locks are freed N/A Not applicable to NOTIFY SUSPEND - STATE
- The state or mode of the lock applied to the resource. Valid values are shown in Table 2.
- ORIG.RSN
- The original reason for the suspension. The task remains suspended
until all suspension causes are cleared. Valid values are shown in Table 2.
Table 2. Reason for Suspension - IRLM SUSPEND Reason Description INTER SYSTEM Intersystem communication required to resolve the lock request IQ Queued IRLM request LOCAL CONTENTION Local resource contention LATCH CONT GENERIC Generic IRLM latch contention LATCH CONT MAIN Main IRLM latch contention LATCH CONT NOTIFY IRLM notify latch contention LATCH CONT RESOURCE IRLM resource latch contention LATCH CONT WORKUNIT IRLM work unit latch contention LS Local storage cannot be exceeded in cross-memory mode NOTIFY MSG SENT Intersystem message sending RETAINED LOCK Contention with a retained lock - PARENT
- The parent token for explicit hierarchical locking.
- HASH
- The lock hash value.
The following fields are printed if both of the following conditions are satisfied:
- The OMEGAMON AI for Db2 subsystem is a member of a data sharing group.
- It is an IRLM suspension.
- aaaaaaaaaaaaaaaaaaaaa
- Stands for the lock attributes, which can be one or more of the
following:
- MODIFY or NMODIFY
- GLOBAL or LOCAL
- P-LOCK or L-LOCK
- XES PROP
- An indicator whether or not IRLM propagated the request to XES. Possible values are Y(es) or N(o).
- XES FORC
- An indicator whether or not the lock was requested to be forced to XES. Possible values are Y(es) or N(o).
- XES ASYN
- An indicator whether or not IRLM sent the request asynchronously
to XES. Possible values are Y(es) or N(o).
This field is only printed if XES PROP=Y.