One bufferpool is automatically created at the time of database creation and one bufferpool we have created above. Now you can check your created bufferpools in current database.
db2 “select bpname,pagesize,npages from syscat.bufferpools”
Make a bufferpool resize automatically
Use the following command to resize the bufferpool automatically. You must have STMM turned on at the database configuration level for this functionality.
Let’s resize the already created bufferpool “new_bufferpool”.
Alter a fixed Bufferpool size
Let’s alter the size of the bufferpool named “new_bufferpool”.