Javatpoint Logo
Javatpoint Logo

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:

Drop a Bufferpool

Verify:

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

Output:

Drop a Bufferpool

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


Next TopicDB2 Tablespaces




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


B.Tech / MCA