I/O
In a DB2 system, the I/O can be categorized into five types.
- Synchronous read I/O
- Sequential prefetch (asynchronous reads)
- Asynchronous writes
- EDM pool reads (DBDs and plan segments)
- Log I/O (mainly writes).
The number of sequential prefetch read requests is also reported, but the number of read requests is not equal to the number of I/O.
None of the I/O types should be considered as repeatable over time. They all depend on the buffer sizes and the workload activity.
DB2 is not aware of any caches being used. That means that DB2 reports an I/O occurrence, even if the cache buffer satisfies the request.