Physical locks in data sharing

A physical lock (P-lock) is a type of page set lock or page lock that is specific to data sharing.

Page set P-Locks
P-locks are used on physical objects stored in buffers (table spaces, index spaces, and partitions).
Retained P-locks
Just as with transaction locks, certain P-locks can be retained because of a system failure.
Page P-locks
At times, a P-lock must be obtained on a page to preserve physical consistency of the data between members. These locks are known as page P-locks.
P-lock monitoring
Monitoring activity of P-locks, especially page P-locks, in a Db2 data sharing environment can help you determine if you need to control inter-Db2 read/write interest.
Options for reducing space map page contention
When you define table spaces and indexes, you have several options to help reduce space map hot spots. These hot spots can occur when a large amount of update, insert, or delete activity occurs on a page set from multiple members of a group.

Parent topic: Tuning group buffer pools