Discarding archive log records

To recover units of recovery, you need log records at least until all current actions are completed. If Db2 terminates abnormally, restart requires all log records since the previous checkpoint or the beginning of the oldest UR that was active at the abend, whichever is first on the log.

To tell whether all units of recovery are complete, read the status counts in the Db2 restart messages. If all counts are zero, no unit-of-recovery actions are pending. If indoubt units of recovery remain, identify and recover them by the methods described in Monitoring and controlling Db2 and its connections.

To recover databases, you need log records and image copies of table spaces. How long you keep log records depends, on how often you make those image copies. If you do not already know what records you want to keep, see Backing up and recovering your data for suggestions about recovery cycles.