Altering buffer pools

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

To alter a buffer pool:

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.

   

   ADB2ZBA2  --------------- Alter Buffer Pools ---------- Row 1 to 49 of 80 
   Command ===>                                                  Scroll ===> CSR  
   
   Commands: VIEW                                       
   Line commands:                                       
    AL - Alter buffer pool  DIS - Display buffer pool   
    A - Auth  RE - Revoke  GR - Grant                   
    ? - Show all line commands                                                     
                                                                                  
       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 

   

3. Issue the AL line command to alter the buffer pool.
   When you press Enter, you can specify the attributes that you want to alter. Then, Db2 Admin Tool issues the -ALTER BUFFERPOOL command.