These buffer pool metrics are reported for each monitored DB2 subsystem.
Displays the number of write I/O operations made during the last polling interval.
Displays the percentage of buffer pool pages that are free for use by other applications.
Displays the total number of times data sets were physically opened for the buffer pool during the last polling interval.
Displays the number of data page access requests made during the last polling interval.
Displays the percentage of time that the data requested is serviced by data already in the buffer pool and not loaded from disk during the last polling interval.
Displays the ratio of the number of buffer pool pages that are written to the number of write operations that are performed during the last polling interval.
Displays the number of update buffer pool pages that are written out to disk during the last polling interval.
Displays the number of times that DB2 failed to honor a prefetch request because the prefetch threshold was reached during the last polling interval.
Displays the number of prefetch read I/O requests made during the last polling interval.
Displays the number of pages that have been read into the buffer pool using sequential prefetch I/O operations during the last polling interval.
Displays the number of requests to pre-read pages for index and table spaces during the last polling interval.
Displays the number of synchronous I/O operations that have occurred to or from DB2 pagesets during the last polling interval.
Displays the number of buffers that are allocated for all virtual buffer pools.
|
Copyright © 2013 CA.
All rights reserved.
|
|