DB2 Version 9.7 for Linux, UNIX, and Windows

log_read_time - Log Read Time monitor element

The total elapsed time spent by the logger reading log data from the disk. For event monitors that write to tables, the value of this element is given in microseconds by using the BIGINT data type.

Table 1. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database dbase Basic
For snapshot monitoring, this counter can be reset.
Table 2. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Database event_db -
Usage
Use this element in conjunction with the log_reads, num_log_read_io, and num_log_data_found_in_buffer elements to determine if:
  • The current disk is adequate for logging.
  • The log buffer size is adequate.