DB2 Version 9.7 for Linux, UNIX, and Windows

current_archive_log - Current Archive Log File Number monitor element

The file number of the log file the DB2® database system is currently archiving. If the DB2 database system is not archiving a log file, the value for this element is SQLM_LOGFILE_NUM_UNKNOWN.

Table 1. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database detail_log Basic
Table 2. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Database event_db -
Usage
Use this element to determine if there is a problem archiving log files. Such problems include:
  • Slow archive media
  • Archive media that is not available