The amount of log (in bytes) that will have
to be redone
for crash recovery.
- Element identifier
- log_to_redo_for_recovery
- Element type
- watermark
Table 1. Snapshot Monitoring Information| Snapshot Level |
Logical Data Grouping |
Monitor Switch |
|---|
| Database |
dbase |
Basic |
Table 2. Event Monitoring Information| Event Type |
Logical Data Grouping |
Monitor Switch |
|---|
| Database |
event_db |
- |
- Usage
- When the snapshot is taken, this value
is calculated based on conditions
at the time of that snapshot. Larger values indicate longer recovery
times
after a system crash. If the value seems excessive, check the log_held_by_dirty_pages monitor
element to see if page cleaning needs
to be tuned. Also check if there are any long running transactions
that need
to be terminated.
DB2 Version 9.7 for Linux, UNIX, and Windows