Global Contention P-Locks

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

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

For formatting reasons, OMEGAMON XE for DB2 PE shows different labels for report and trace. The following example shows both layouts, the report on the left, and the trace layout on the right.

Accounting - Global Contention P-Locks

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


Report:                                                           Trace:

GLOBAL       CONTENTION       P-LOCKS  AVERAGE TIME  AV.EVENT     GLOBAL       CONTENTION       P-LOCKS  ELAPSED TIME    EVENTS
-------------------------------------  ------------  --------     -------------------------------------  ------------  --------
P-LOCKS                                    0.000000      0.00     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

P-LOCKS - AVERAGE TIME/ELAPSED TIME

The accumulated global contention wait time for all P-locks.

Field Name: ADPLSUST

P-LOCKS - AV.EVENT/EVENTS

The number of global contention waits for all P-locks.

Field Name: ADPLSUSC

PAGESET/PARTITION - AVERAGE TIME/ELAPSED TIME

The accumulated global contention time for pageset and partition P-locks.

Field Name: QWACAWTN

PAGESET/PARTITION - AV.EVENT/EVENTS

The number of global contention waits for pageset and partition P-locks.

Field Name: ADPSSUSC

PAGE - AVERAGE TIME/ELAPSED TIME

The accumulated global contention wait time for page P-locks.

Field Name: QWACAWTO

PAGE - AV.EVENT/EVENTS

The number of global contention waits for page P-locks.

Field Name: ADPPSUSC

OTHER - AVERAGE TIME/ELAPSED TIME

The accumulated global contention wait time for other P-locks. Includes suspension for Castout P-Locks and DBET locks. It could be because of Index Split processing which can be minimized if the Index key size is not large. If you can minimize the number of Index Keys in the Index, it will help to reduce the number of Index splits.

Field Name: QWACAWTQ

OTHER - AV.EVENT/EVENTS

The number of global contention waits for other P-locks.

Field Name: ADPOSUSC