These buffer pool metrics are reported for each monitored DB2 Data Sharing Group.
Displays the total number of write I/O operations that member subsystems performed during the last polling interval.
Displays the percentage of buffer pool pages from member subsystems that are free for use by other applications.
Displays the total number of times data sets were physically opened for buffer pools in member subsystems during the last polling interval.
Displays the total number of data page access requests that member subsystems made during the last polling interval.
Displays the percentage of time that the data already in the buffer pool serviced the data that member subsystems request during the last polling interval. The requested data was not loaded from the disk.
Displays the ratio of the following numbers during the last polling interval: The number of buffer pool pages that member subsystems wrote to the total number of write operations that were performed.
Displays the total number of updated buffer pool pages that member subsystems wrote out to disk during the last polling interval.
Displays the total number of times that DB2 failed to honor a prefetch request because the prefetch threshold was reached during the last polling interval.
Displays the total number of prefetch read I/O requests that member subsystems made during the last polling interval.
Displays the total number of pages that member subsystems read into buffer pools using sequential prefetch I/O operations during the last polling interval.
Displays the total number of requests that member subsystems made to preread pages for index and table spaces during the last polling interval.
Displays the total number of synchronous I/O operations to or from DB2 page sets for member subsystems during the last polling interval.
Displays the total number of buffers that are allocated for virtual buffer pools in member subsystems.
|
Copyright © 2014 CA.
All rights reserved.
|
|