8.5. Buffer Pools
The database buffer pools are the area where all of the work in a database really happens. All regular data and index keys are read, scanned, updated, inserted, and deleted within the database buffer pools.
The database buffer pool area is a piece of real memory that is used by DB2 to temporarily store (cache) the regular data and index pages when they are read from disk to be scanned or modified. The buffer pool area improves the performance of the database, since the pages can be accessed much more quickly from memory than from disk.
When you connect to a database, the database buffer pools (along with the lock list, database heap, and so on) are allocated in memory. When you (and anyone else using the database) disconnect ...
Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
