Lock monitoring with the DISPLAY DATABASE command

Use the LOCKS ONLY option on DISPLAY DATABASE to display information about page set, partition, or table locks that are held on resources.

The lock column of the display describes the type and duration of locks used by corresponding agents.

Begin general-use programming interface information.

The following figure is an example of output of DISPLAY DATABASE for a table space. The application identified as LSS001 on member DB1A has locked partitions 1 and 2. LSS002 on member DB2A has locked partitions 1 and 3. Partition 4, which has no locks, is not on the display because the ONLY option of DISPLAY DATABASE was used.

Figure 1. Example DISPLAY DATABASE LOCKS for a table space

NAME     TYPE PART STATUS             CONNID   CORRID       LOCKINFO
-------- ---- ---- ------------------ -------- ------------ ---------
TSPART   TS    01  RO                 LSS001   DSN2SQL      H-IS,P,C
     -                 MEMBER NAME DB1A
TSPART   TS    01  RO                                       H-S,PP,I
     -                 MEMBER NAME DB1A
TSPART   TS    01  RO                 LSS002   DSN2SQL      H-IS,P,C
     -                 MEMBER NAME DB2A
TSPART   TS    01  RO                                       H-S,PP,I
     -                 MEMBER NAME DB2A
TSPART   TS    02  RW                 LSS001   DSN2SQL      H-IS,P,C
     -                 MEMBER NAME DB1A
TSPART   TS    02  RW                                       H-S,PP,I
     -                 MEMBER NAME DB1A
TSPART   TS    03  RW                 LSS002   DSN2SQL      H-IS,P,C
     -                 MEMBER NAME DB2A
TSPART   TS    03  RW                                       H-S,PP,I
     -                 MEMBER NAME DB2A

End general-use programming interface information.