Determining GBP-dependency for a particular member

At times you might need to know what the impact is to bring down a particular member or to disconnect a particular member from the group buffer pool.

You can use the DISPLAY BUFFERPOOL command with the GBPDEP(Y) option to discover whether a particular member has any page sets opened that are GBP-dependent:

-DB1A DISPLAY BUFFERPOOL(BP0) GBPDEP(Y)

Your output will be similar to the output that is shown in the figure below.

Figure 1. Sample DISPLAY BUFFERPOOL output indicating page sets and partitions are group-buffer-pool-dependent

@DIS BPOOL(BP0) GBPDEP(Y)
DSNB401I @ BUFFERPOOL NAME BP0, BUFFERPOOL ID 0, USE COUNT 21
DSNB402I @ VIRTUAL BUFFERPOOL SIZE = 500 BUFFERS
             ALLOCATED       =      500   TO BE DELETED   =        0
             IN-USE/UPDATED  =        0
DSNB406I @ VIRTUAL BUFFERPOOL TYPE -
             CURRENT            = PRIMARY
             PENDING            = PRIMARY
           PAGE STEALING METHOD = LRU
DSNB404I @ THRESHOLDS -
            VP SEQUENTIAL    = 80   
            DEFERRED WRITE   = 85   VERTICAL DEFERRED WRT  = 80,0
            PARALLEL SEQUENTIAL = 50   ASSISTING PARALLEL SEQT=  0
DSNB460I @
-------------PAGE SET/PARTITION LIST INFORMATION--------------
                                 ------DATA SHARING INFO------
                          TS GBP  MEMBER  CASTOUT  USE  P-LOCK
DATABASE SPACE NAME  PART IX DEP   NAME    OWNER  COUNT STATE
======== =========== ==== == === ======== ======= ===== ======
DSNDB01  DSNLLX02         IX  Y  DB1AA        Y       0   IX
                                 DB1AB                0   IX
DSN8D71A DSN8S71E     001 TS  Y  DB1AA        Y       0   IX
                                 DB1AB                0   IX
                      003 TS  Y  DB1AA        Y       0   IX
                                 DB1AB                0   IX
DSNDB01  DSNLLX01         IX  Y  DB1AA        Y       0   IX
                                 DB1AB                0   IX
         SYSLGRNX         TS  Y  DB1AA        Y       0   IX
                                 DB1AB                0   IX
DSN9022I @ DSNB1CMD '-DIS BPOOL' NORMAL COMPLETION