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.

More overhead exists when inter-Db2 read/write interest exists in a page set. Although Db2 dynamically tracks inter-Db2 read/write interest, which helps avoid data sharing overhead when it is not needed, you will pay some cost for the advantages of data sharing.

If excessive global contention exists that cannot be resolved by any tuning measures, you might need to reduce the locking overhead by keeping some transactions and data together on a single system.