Subsystem Pools
In the DBM1 address space there are many objects critical to the operation of DB2. Here we will take a brief look at buffer pools, the RID pool, EDM pool and the Sort pool.
Buffer Pools
Buffer pools are database objects used to cache database data pages in memory. If an object's data page is placed in a buffer pool, physical I/O access to disks will be avoided. Buffer pools can be assigned to cache only a particular table space's data. This is assigned within the table space definition.
Buffer pools are areas of virtual storage that temporarily store pages of table spaces or indexes. When a program accesses a row of a table, DB2 places the page containing that row in a buffer. When a program changes a row of a table, DB2 must ...
Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide 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.
