DB2 Version 10.1 for Linux, UNIX, and Windows

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