Moving data efficiently through the system

As data progresses through a DB2 subsystem, it moves from disk to memory and to the end user or to applications. You need to tune the system resources and objects that contain data to keep the flow of data efficient. This section addresses how to tune buffer pools, table spaces, and indexes.

Caching data: The role of buffer pools

Buffer pools are areas of virtual storage that temporarily store pages of data that have been fetched from table spaces or indexes. Buffer pools are a key element of DB2 performance. DB2 can retrieve a page from a buffer pool significantly faster than it can from disk. When data is already in a buffer, an application program avoids the delay of waiting for DB2 to retrieve the ...

Get Official Introduction to DB2® for z/OS®, The, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.