DB2: Bufferpools Cheat Sheet

Listing the available bufferpools in the current database directory

db2 select * from syscat.bufferpools   

Creating the bufferpool

db2 create bufferpool <bp_name> pagesize <size> 

Dropping the bufferpool

drop bufferpool <bp_name> 

Leave a Reply

Your email address will not be published. Required fields are marked *