How to find information about page P-locks

Page P-locking activity is recorded, along with the rest of the data sharing locking information, in the statistics and accounting trace classes.

You can find more detail about those page P-locks in performance trace class 21 (IFCID 0259). IFCID 0259 allows you to monitor page P-locking without having to use a full Db2 lock trace. IFCID 0259 is mapped by DSNDQW04.