Verify Bufferpools
One bufferpool is consequently made at the hour of database creation and one bufferpool we have made previously. Presently you can check your made bufferpools in current database.
Example:
db2 "select bpname,pagesize,npages from syscat.bufferpools" Make a bufferpool resize automatically
Utilize the accompanying order to resize the bufferpool naturally. You should have STMM turned on at the database setup level for this usefulness.
Syntax:
db2 alter bufferpool <bufferpool_name> size AUTOMATIC
Example:
Let's resize the already created bufferpool "new_bufferpool".
db2 alter bufferpool new_bufferpool size AUTOMATIC
Alter a fixed Bufferpool size
Syntax:
db2 ALTER BUFFERPOOL <bufferpool_name> SIZE <size_value>
Example:
Let's alter the size of the bufferpool named "new_bufferpool".
db2 ALTER BUFFERPOOL new_bufferpool SIZE 15000;