Understanding DB2®: Learning Visually with Examples

7.5. Buffer Pools

The database buffer pool is a piece of real memory used by DB2 to temporarily store (cache) regular data and index pages when they are read from disk to be scanned or modified. The buffer pool improves the performance of the database because the pages can be accessed much more quickly from memory than from disk.

When you create a database, a default buffer pool, IBMDEFAULTBP, is automatically created. This buffer pool is associated with the default table spaces SYSCATSPACE, TEMPSPACE1, and USERSPACE1, and you cannot drop it.

To create a buffer pool, use the CREATE BUFFERPOOL statement. This statement allows you to indicate, among other things, how large the buffer pool will be and which page size it will use. Refer to Chapter ...