Total Direct I/O Time (ms) - Database

Identifier:db2.db_total_direct_io_time

Database Object Monitored:Database

Category:Buffer Pool and I/O

Description:Total direct I/O time

Equation:database.direct_read_time + database.direct_write_time

Usage Notes:Direct I/O does not use the buffer pool. This value needs to be taken into account when investigating which database may be experiencing high I/O load. Direct I/O occurs when:

Reading VARCHAR columns

Reading LOB columns

The database is being backed up or restored

Note:

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