Controlling the number of I/O operations

You can improve the response time of your applications and queries by reducing the number of unnecessary I/O operations.

Read operations and prefetch I/O
Db2 uses prefetch I/O to read data in almost all cases, but uses synchronous I/O in certain cases.
Write operations
Write operations are usually performed concurrently with user requests.
Making buffer pools large enough for the workload
You might improve the performance of I/O operations by increasing the size of your buffer pools.

Parent topic: Managing I/O processing, response time, and throughput

Related concepts

Planning the placement of Db2 data sets
How Db2 assigns I/O priorities

Related tasks

Managing the opening and closing of data sets
Estimating concurrent I/O requests
Monitoring I/O activity of data sets
Improving performance for LOB data by using inline LOB columns
Minimizing the use of real and virtual storage
Designing EDM storage space for performance
Choosing data page sizes