Total Direct I/O Time (ms) - Table Space

Identifier:db2.tbsp_tot_direct_io_time

Database Object Monitored:Table Space

Category:Buffer Pool and I/O

Description:Total direct I/O time

Equation:tablespace.direct_read_time + tablespace.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.