Package Global Contention P-Locks - Class 8

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

This block provides global contention information for a physical lock (P-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.

The following example shows both layouts, the report on the left, and the trace layout on the right.

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

Accounting - Package Global Contention P-Locks - Class 8

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


Report:                                                Trace:

AYRSD020                   AVERAGE TIME  AV.EVENT      DSNTEP2                    ELAPSED TIME    EVENTS
-------------------------  ------------  --------      -------------------------  ------------  --------
GLOBAL CONTENTION P-LOCKS      0.000000      0.00      GLOBAL CONTENTION P-LOCKS      0.000000         0
 PAGESET/PARTITION             0.000000      0.00       PAGESET/PARTITION             0.000000         0
 PAGE                          0.000000      0.00       PAGE                          0.000000         0
 OTHER                         0.000000      0.00       OTHER                         0.000000         0

GLOBAL CONTENTION P-LOCKS - AVERAGE TIME/ELAPSED TIME

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

Field Name: APPLSUST

GLOBAL CONTENTION P-LOCKS - AV.EVENT/EVENTS

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

Field Name: APPLSUSC

PAGESET/PARTITION - AVERAGE TIME/ELAPSED TIME

The accumulated wait time due to global contention for pageset/partition P-Locks.

Field Name: QPACAWTN

PAGESET/PARTITION - AV.EVENT/EVENTS

The number of wait trace events processed for waits for global contention for pageset/partition P-Locks.

Field Name: APPSSUSC

PAGE - AVERAGE TIME/ELAPSED TIME

The accumulated wait time due to global contention for page P-Locks.

Field Name: QPACAWTO

PAGE - AV.EVENT/EVENTS

The number of wait trace events processed for waits for global contention for page P-Locks.

Field Name: APPPSUSC

OTHER - AVERAGE TIME/ELAPSED TIME

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

Field Name: QPACAWTQ

OTHER - AV.EVENT/EVENTS

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

Field Name: APPOSUSC