IBM Db2 11.1 Certification Guide

Altering a buffer pool

You can modify the following listed attributes of a buffer pool by using the ALTER BUFFERPOOL statement:

• SIZE: The number of pages allocated for the specific buffer pool
• NUMBLOCKPAGES: The block based total area
• BLOCKSIZE: The block size, within the block based total area

• ESTORE: Enabling or disabling the extended storage
• DBPGNAME: The database partition group

If you want to change the block based total area and the block size, you can do so by executing the following statement:

ALTER BUFFERPOOL bpool_08k NUMBLOCKPAGES 8000 BLOCKSIZE 256;