Ways to move data efficiently through the system

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

The role of buffer pools in caching data
Buffer pools are a key element of DB2 performance, and help you to avoid delays when retrieving data.
The effect of data compression on performance
In many cases, compressing the data in a table space significantly reduces the amount of disk space that is needed to store data. Compressing data can also help improve buffer pool performance. For example, you can store more data in a buffer pool, and DB2 can scan large amounts of data more easily.
How data organization can affect performance
To achieve optimal performance for table spaces and indexes, you need to keep data organized efficiently. The use of space and the organization of data in a table space and the associated indexes sometimes affects performance.

Parent topic: DB2 performance management