Package Global Contention L-Locks - Class 8

This topic shows detailed information about Accounting - Package Global Contention L-Locks - Class 8.

This block provides global contention information for a logical lock (L-lock) at package level. It shows conflicts on locking requests between different Db2 members of a data sharing group when those members are trying to serialize shared resources.

Note: The current package name is shown in the header line of the block instead of this block title.

Accounting - Package Global Contention L-Locks - Class 8

The field labels shown in the following sample layout of Accounting - Package Global Contention L-Locks - Class 8 are described in the following section.


Report:                                               Trace:

AYRSD020                   AVERAGE TIME  AV.EVENT     DSNTEP2                    ELAPSED TIME    EVENTS
-------------------------  ------------  --------     -------------------------  ------------  --------
GLOBAL CONTENTION L-LOCKS      0.000000      0.00     GLOBAL CONTENTION L-LOCKS      0.000000         0
 PARENT (DB,TS,TAB,PART)       0.000000      0.00      PARENT (DB,TS,TAB,PART)       0.000000         0
 CHILD  (PAGE,ROW)             0.000000      0.00      CHILD  (PAGE,ROW)             0.000000         0
 OTHER                         0.000000      0.00      OTHER                         0.000000         0

GLOBAL CONTENTION L-LOCKS - AVERAGE TIME/ELAPSED TIME

The accumulated wait times due to global contention for all L-Locks.

Field Name: APLKSUST

GLOBAL CONTENTION L-LOCKS - AV.EVENT/EVENTS

The accumulated wait trace events processed for waits for global contention of all L-Locks.

Field Name: APLKSUSC

PARENT (DB,TS,TAB,PART) - AVERAGE TIME/ELAPSED TIME

The accumulated wait time due to global contention for parent L-Locks. Parent L-Locks are any of the following L-Lock types: database, tablespace, table, or partition.

Field Name: QPACAWTJ

PARENT (DB,TS,TAB,PART) - AV.EVENT/EVENTS

The number of wait trace events processed for waits for global contention for parent L-Locks.

Field Name: APLPSUSC

CHILD (PAGE,ROW) - AVERAGE TIME/ELAPSED TIME

The accumulated wait time due to global contention for child L-Locks. Child L-locks are any of the following L-Lock types: page or row.

Field Name: QPACAWTK

CHILD (PAGE,ROW) - AV.EVENT/EVENTS

The number of wait trace events processed for waits for global contention for child L-Locks.

Field Name: APLCSUSC

OTHER - AVERAGE TIME/ELAPSED TIME

The accumulated wait time due to global contention for other L-Locks.

Field Name: QPACAWTM

OTHER - AV.EVENT/EVENTS

The number of wait trace events processed for waits for global contention for other L-Locks.

Field Name: APLOSUSC