Identifier:db2.db_pages_per_prefetch
Database Object Monitored:Database
Category:Buffer Pool and I/O
Description:Number of data pages read per prefetch request during the interval
Equation:DELTA(database.pool_async_data_reads) / DELTA(database.pool_async_data_read_reqs)
Usage Notes:This performance variable shows the effectiveness of prefetching, and how well clustered the data is.
| Note: | For multiple buffer pools, the data is combined and only the aggregate number is returned. |