DB2 Bufferpools Cheat Sheet

In DB2, Bufferpool is a part of main memory space which is allocated by the database manager. The purpose of bufferpools is to cache table and index data from disk. All databases have their own bufferpools.

Each new database has a default buffer pool defined, called IBMDEFAULTBP. Additional buffer pools can be created, dropped, and modified, using the CREATE BUFFERPOOL, DROP BUFFERPOOL, and ALTER BUFFERPOOL statements. The SYSCAT.BUFFERPOOLS catalog view accesses the information for the buffer pools defined in the database.

In this blogpost you will see and learn Db2 Bufferpools related syntaxes and methods which help you using Db2 database product.

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> 

That's all in this post. If you liked this blog and interested in knowing more about IBM Db2. Please Like, Follow, Share & Subscribe to www.ImJhaChandan.com.