Monitoring I/O and storage

You can monitor to the use of real and virtual storage by Db2.

Monitoring I/O activity of data sets
The best way to monitor your I/O activity against database data sets is through IFCID 0199 (statistics class 8).
Monitoring and tuning buffer pools by using online commands
The DISPLAY BUFFERPOOL and ALTER BUFFERPOOL commands enable you to monitor and tune buffer pools on line, while Db2 is running, without the overhead of running traces.
The buffer pool hit ratio
Buffer pool hit ratio is a measure of how often a page access (a getpage) is satisfied without requiring an I/O operation.
Using OMEGAMON to monitor buffer pool statistics
You can find information about buffer pools in the IBM® OMEGAMON® AI for Db2 statistics report.
Monitoring work file data sets
You should monitor how work files use devices, both in terms of space use and I/O response times.

Parent topic: Monitoring performance

Related tasks