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