DB2 Version 9.7 for Linux, UNIX, and Windows

pool_async_xda_read_reqs - Buffer pool asynchronous XDA read requests monitor element

The number of asynchronous read requests for XML storage object (XDA) data.

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

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 average number of XML storage object data pages read per asynchronous request, use the following formula:

 pool_async_xda_reads / pool_async_xda_read_reqs

This average can help you determine the amount of asynchronous I/O done in each interaction with the prefetcher.