Altering buffer pools

You can alter the attributes of active or inactive buffer pools.

Procedure

  1. On the DB2 Administration Menu (ADB2) panel, specify Z, and press Enter.
    The System Administration (ADB2Z) panel is displayed.
  2. Specify option BA, and press Enter.
    The Alter Buffer Pools (ADB2ZBA2) panel is displayed, as shown in the following figure.
    Figure 1. Alter Buffer Pools (ADB2ZBA2) panel
    ADB2ZBA2  --------------- Alter Buffer Pools ---------- Row 1 to 49 of 80 
Command ===>                                                  Scroll ===> CSR  
                                                                               
Line commands:                                                                 
 AL - Alter buffer pool  DIS - Display buffer pool                             
                                                                               
    BP     VP   VPSZ VPSZ FM PG       VP    VP PG         Int1  Int2  VP X Auto
Sel Name   Size Min  Max  SZ Steal  SEQT PSEQT FIX  DWQT VDWQT VDWQT PSEQT Size
    *         *    *    * *  *         *     * *       *     *     *     * *   
--- ------ ---> ---> ---> -- ----- ----- ----- --- ----- ----- ----- ----- ----
    BP0    2000 0    0    1M LRU      80    50 NO     30     5     0     0 YES 
    BP1    2000 1000 3000 1M LRU      80    50 NO     30     5     0     0 YES 
    BP2    2000 2002 2000 1M LRU      80    50 NO     30     5     0     0 NO  
    BP3    0    0    0    4K LRU      80    50 NO     30     5     0     0 NO  
    BP4    1000 0    0    4K LRU      80    50 NO     30     5     0     0 NO  
    BP5    0    0    0    4K LRU      80    50 NO     30     5     0     0 NO  
    BP6    0    0    0    4K LRU      80    50 NO     30     5     0     0 NO  
    BP7    0    0    0    4K LRU      80    50 NO     30     5     0     0 NO  
    BP8    0    0    0    4K LRU      80    50 NO     30     5     0     0 NO  
    BP9    0    0    0    4K LRU      80    50 NO     30     5     0     0 NO  
    BP10   0    0    0    4K LRU      80    50 NO     30     5     0     0 NO  
    BP11   1000 0    0    4K LRU      80    50 NO     30     5     0     0 NO  
    BP12   0    0    0    4K LRU      80    50 NO     30     5     0     0 NO  
    BP13   0    0    0    4K LRU      80    50 NO     30     5     0     0 NO

    The following columns are available on this panel:

    Sel
    Input field where you enter one of the line commands listed on the panel.
    BP NAME
    Buffer pool name.
    VP SIZE
    Virtual buffer pool size.
    VPSZ MIN
    The minimum size for the buffer pool.
    VPSZ MAX
    The maximum size for the buffer pool.
    FM SZ
    The frame size for the buffer pool.
    HP SIZE
    Hiperpool size.
    CAST OUT
    Hiperspace* CASTOUT value.
    VP SEQT
    Virtual sequential steal threshold.
    VP PSEQT
    Virtual parallel sequential threshold.
    HP SEQT
    Hiperpool sequential steal threshold.
    DWQT
    Deferred write threshold.
    VDWQT
    Vertical deferred write threshold.
    VP X PSEQT
    Assisting virtual parallel sequential threshold.
    Auto Size
    Specifies whether the buffer pool adjustment is turned on or off.
    NO
    Specifies that the buffer pool does not use Workload Manager (WLM) services for automatic buffer pool sizing adjustment. This is the default.
    YES
    Specifies that the buffer pool uses WLM services, if available, to automatically adjust the size of the buffer pool based on dynamic monitoring of the workload goals and the available storage on the system.
  3. Issue one of the following line commands:
    • AL to alter a buffer pool. When you press Enter, Db2 Admin Tool issues the -ALTER BUFFERPOOL command.
    • DIS to display buffer pool. When you press Enter, Db2 Admin Tool issues the -DISPLAY BUFFERPOOL command.

    The information Db2 Admin Tool returns to you from the commands is in ISPF browse format.