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.