---

Drop Bufferpool 

You can drop a bufferpool by utilizing "drop bufferpool" order. It is recommended to check if any tablespace is appointed to bufferpool before utilizing drop order. 

Syntax:

drop bufferpool <bp_name>   

Example:

We should drop the bufferpool named "new_bufferpool". 

db2 drop bufferpool new_bufferpool    

Verify:

db2 "select bpname,pagesize,npages from syscat.bufferpools" 

You can see that there is only one bufferpool in the rundown and "new_bufferpool" is dropped.