DB2 Version 9.7 for Linux, UNIX, and Windows

pool_async_index_read_reqs - Buffer pool asynchronous index read requests monitor element

The number of asynchronous read requests for index pages.

Table 1. Table Function Monitoring Information
Table Function Monitor Element Collection Command and Level
MON_GET_BUFFERPOOL table function - Get buffer pool metrics DATA OBJECT METRICS BASE
MON_GET_TABLESPACE table function - Get table space metrics DATA OBJECT METRICS BASE
Table 2. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Buffer Pool
Table Space tablespace Buffer Pool
Buffer Pool bufferpool Buffer Pool
For snapshot monitoring, this counter can be reset.
Table 3. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Database event_db -
Tablespaces event_tablespace -
Usage
To calculate the number of index pages read per asynchronous request, use the following formula:
  pool_async_index_reads / pool_async_index_read_reqs
This average can help you determine the amount of asynchronous I/O done for index pages in each interaction with the prefetcher.