Displaying the castout owner

You can use the DISPLAY DATABASE command or the DISPLAY BUFFERPOOL command to display the castout owner for a page set or partition.

Begin general-use programming interface information.

Use the DISPLAY DATABASE command with the LOCKS option to display the current castout owner for a given page set:

-DB1A    DISPLAY DATABASE(TESTDB) SPACE(*) LOCKS

Display the castout owner for a particular page set or partition with (CO) by the member name, as shown in the following figure.

Figure 1. Partial DISPLAY DATABASE output showing castout owner for a partition

⋮
TBS43    TS    01  RW                                       H-SIX,PP,I
    -                  MEMBER NAME DB2A     (CO)
TBS43    TS    02  RW                 BATCH    SELEC        H-IS,P,C
    -                  MEMBER NAME DB1A
⋮

Use the DISPLAY BUFFERPOOL command with the CASTOWNR keyword to determine for which page sets or partitions the members hold castout ownership:

-DIS BUFFERPOOL(BP0) CASTOWNR(Y)

The following figure shows output that lists the members that hold the page set or partition P-lock in "U" state.

Figure 2. Partial DISPLAY DATABASE output showing the list of members that hold the page set or partition P-lock in "U" state

@DIS BPOOL(BP0) CASTOWNR(Y)
DSNB401I @ BUFFERPOOL NAME BP0, BUFFERPOOL ID 0, USE COUNT 40
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  V61A        Y        0   IX
                                 V61B                 0   IX
DSN8D71A DSN8S71E     001 TS  Y  V61A        Y        1   SIX
                      003 TS  Y  V61A        Y        1   SIX
DSNDB01  DSNLLX01         IX  Y  V61A        Y        0   IX
                                 V61B                 0   IX
         SYSLGRNX         TS  Y  V61A        Y        0   IX
                                 V61B                 0   IX
DSN9022I @ DSNB1CMD '-DIS BPOOL' NORMAL COMPLETION

End general-use programming interface information.