DB2 Version 9.7 for Linux, UNIX, and Windows

pool_async_read_time - Buffer Pool Asynchronous Read Time monitor element

Indicates the total amount of time spent reading in data and index pages from the table space containers (physical) by asynchronous engine dispatchable units (EDUs) for all types of table spaces. This value is given in milliseconds.

Element identifier: pool_async_read_time
Element type: counter

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection 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

You can use this element to calculate the elapsed time for synchronous reading, using the following formula:

  pool_read_time - pool_async_read_time

You can also use this element to calculate the average asynchronous read time using the following formula:

  pool_async_read_time / pool_async_data_reads

These calculations can be used to understand the I/O work being performed.