Dropping buffer pools
When dropping buffer pools, ensure
that no table spaces are assigned to those buffer pools.
You
cannot drop the IBMDEFAULTBP buffer pool.
About this task
Disk storage might not be released until the next connection to the database. Storage memory is not released from a dropped buffer pool until the database is stopped. Buffer pool memory is released immediately, to be used by the database manager.
Procedure
To drop buffer pools, use the DROP BUFFERPOOL statement.
DROP BUFFERPOOL buffer-pool-name