Create a Bufferpool

On the off chance that you need to make another bufferpool for database server, you simply need two parameters named "bufferpool name" and "size of page". Utilize the accompanying question to make another bufferpool: 

Syntax:

db2 create bufferpool <bp_name> pagesize <size>  

Here,'bp_name' determines name of the bufferpool and 'size' indicates size for page. You have to pronounce for bufferpools (4K,8K,16K,32K) 

Example:

We should make another bufferpool named "new_bufferpool" where pagesize is 8192. 

db2 create bufferpool new_bufferpool pagesize 8192