DB2 Drop Bufferpool

85

Drop Bufferpool

You can drop a bufferpool by using “drop bufferpool” command. It is suggested to check if any tablespace is assigned to bufferpool before using drop command.

Syntax:

Example:

Let’s drop the bufferpool named “new_bufferpool”.

Output:

---

Verify:

db2 “select bpname,pagesize,npages from syscat.bufferpools”

Output:

You can see that there is only one bufferpool in the list and “new_bufferpool” is dropped.