Displaying GBP-dependent page sets

You can use the DISPLAY DATABASE command to determine if a page set is GBP-dependent.

Begin general-use programming interface information.

To determine if a particular page set is GBP-dependent, use the DISPLAY DATABASE command with the LOCKS option:

-DB1A  DISPLAY DATABASE(DSN8D13A) SPACE(DSN8S13D) LOCKS

Your output will be similar to the output that is shown in the following figure:

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

Page set P-locks are identified by a member name rather than a correlation ID. They are also identified by 'PP' as the lock unit. If any of the P-locks shown in the output have a lock state of NSU, SIX, or IX, the identified page set is GBP-dependent. Thus, the output in the figure above shows that DSN8S13D is GBP-dependent. End general-use programming interface information.