Altering buffer pools

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

Procedure

To alter a buffer pool:

On the DB2 Administration Menu (ADB2) panel, specify Z, and press Enter.

On the System Administration (ADB2Z) panel, specify option BA, and press Enter.

Buffer pools and their associated attributes are 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  

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

Tip: To see more buffer pool attributes, including VPCLOSET and REFPF, scroll right. (VPCLOSET and REFPF are displayed only if you are running Db2® 13 function level 507 or later.)

Issue the AL line command next to the buffer pool that you want to alter.

On the Alter Buffer Pool (ADB2ZBA8) panel, specify the attributes that you want to alter, and press Enter.

Figure 2. Alter Buffer Pool (ADB2ZBA8) panel

ADB2ZBA8  -------------------- DD1A Alter Buffer Pool ------------------- 17:34
Command ===>                                                                   
                                                                               
                                                                   More:     + 
 -ALTER BUFFERPOOL                                                             
    Buffer pool name  . . . . . . BP0       (BP0-49, BP8K0-9, BP16K0-9,        
                                             BP32K0-9)                         
    VPSIZE  . . . . . . . . . . . 20000     (0-250MB for 4K, 0-31250KB for 32K)
    VPSIZEMIN   . . . . . . . . . 0         (2K-250M for BP0,                  
                                             1K-125M for BP8K0,                
                                             500-6250K for BP16K0,             
                                             250-3125K for BP32K               
                                             otherwise 1-20000 or *)           
    VPSIZEMAX . . . . . . . . . . 0         (2K-250M for BP0,                  
                                             1K-125M for BP8K0,                
                                             500-6250K for BP16K0,             
                                             250-3125K for BP32K               
                                             otherwise >=20000 or *)           
    FRAMESIZE . . . . . . . . . . 4K        (4K, 1M or 2G)                     
    PGSTEAL . . . . . . . . . . . LRU       (L-LRU, F-FIFO or N-NONE)          
    PGFIX . . . . . . . . . . . . NO        (Yes/No)                           
    VPSEQT  . . . . . . . . . . . 80        (0-100)                            
    VPPSEQT . . . . . . . . . . . 50        (0-100)                            
    VPCLOSET  . . . . . . . . . . 60        (0-32767)                          
    DWQT  . . . . . . . . . . . . 30        (0-90)                             
    VDWQT                                                                      
      Vertical DWQT, integer1 . . 5         (0-90)                             
      Vertical DWQT, integer2 . . 0         (0-9999)                           
    AUTOSIZE  . . . . . . . . . . NO        (Yes/No)                           
    SPSIZE  . . . . . . . . . . . 0         (BP0-49:  Min:200, Max:250M-VPSIZE,
                                             BP8K0-9: Min:100, Max:125M-VPSIZE,
                                             BP16K0-9:Min:50, Max:62.5M-VPSIZE,
    SPSEQT  . . . . . . . . . . . 0         (0-100)           
    REFPF . . . . . . . . . . . . NO        (Yes/No)

Note: The VPCLOSET and REFPF fields are displayed only if you are running Db2 13 function level 507 or later.

Db2 Admin Tool issues the ALTER BUFFERPOOL command.