How to find information about page set P-locks

You can use the DISPLAY DATABASE command with the LOCKS option to find information about page set P-locks, including which member is holding or waiting for P-locks, and whether P-locks are being held because of a Db2 failure.

The following figure has sample output obtained from the command.

Figure 1. Sample DISPLAY DATABASE output showing GBP-dependent table spaces

 NAME     TYPE PART STATUS             CONNID   CORRID       LOCKINFO
 -------- ---- ---- ------------------ -------- ------------ ----------
 DSN8S13D    TS        RW                                       H-IX,PP,I
                                       MEMBER NAME DB1A (CO)
 DSN8S13D    TS        RW                                       H-IX,PP,I
                                       MEMBER NAME DB2A

A PP in the LOCKINFO field of the output indicates that a particular lock is a page set or partition P-lock.

You can also obtain information about P-locks, along with information about transaction locking, from the statistics and accounting traces. Performance class 20 (IFCID 0251) also contains information about P-lock negotiation requests. IFCID 0251 is mapped by DSNDQW04.