Bufferpool Name



Snapshot Level
Table Space


Logical Data Grouping
bufferpool


Monitor Switch
Basic


Resettable


No


 


Element Name
Element Type



bp_name
information

 

Description:  The name of the buffer pool.

Usage:  A new database has a default buffer pool called IBMDEFAULTBP with a size determined by the platform. Each database requires at least one buffer pool. However, depending on your needs you may choose to create several buffer pools, each of a different size, for a single database. The CREATE, ALTER, and DROP BUFFERPOOL statements allow you to create, change, or remove a buffer pool.