Index Read Rate graph
The Index Read Rate graph depicts aspects of index page retrieval from buffer pools for the selected application. The graph contains the following series, which measure index page retrieval rates for consecutive monitoring intervals. Each rate is based on the number of pages read per second.
-
Logical —Plots the rate of index page read requests directed at the buffer pool.
-
Physical —Plots the rate at which logical index page requests required actual database I/O to get the index pages into the buffer pool first. When the physical read rate is consistently higher than the logical read rate, the buffer pool is not being used effectively.
For related statistical information
The Statistics tab shows the buffer pool write counts used to generate this graph. The names for these statistics begin with Buffer Pool. These statistics are derived from the POOL data elements that the DB2 snapshot monitor captures.