DB2 Version 9.7 for Linux, UNIX, and Windows

FP4: Archive log files can be checked for validity

In Version 9.7 Fix Pack 4 and later fix packs, you can check the validity of archive log files with the db2cklog command before using these files during a rollforward recovery operation.

The db2cklog command reads either a single log file or a range of log files. You can use this command immediately before a rollforward recovery to ensure that the recovery operation will not fail because of a problem with a log file. If the db2cklog command returns error messages or warnings for a log file, do not use that file during rollforward recovery without addressing the problems.

If IBM® Software Support suspects that an invalid log file is causing a problem with your data server, you might be asked to run the db2cklog command. You can also use the command to validate each log file after it is closed and copied to the log archive directory.