Buffer Pool I/Os per Second - Database

Identifier:db2.db_pool_io_rate

Database Object Monitored:Database

Category:Buffer Pool and I/O

Description:Buffer pool I/O rate for database (count/second)

Equation:RATE(database.pool_data_p_reads + database.pool_data_writes + database.pool_index_p_reads + database.pool_index_writes)

Usage Notes:The buffer pool I/O rate at the database level helps you determine which database has a heavy I/O load. In conjunction with the hit ratio statistic, and the characteristics of the applications executing, the I/O load may require adjustment of buffpage, or applications may require further tuning.

Note:For multiple buffer pools, the data is combined and only the aggregate number is returned.