O'Reilly logo

DB2® Universal Database for OS/390® Version 7.1 Certification Guide by Susan Lawson, Richard Yevich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required