Recovering from failure during log initialization or current status rebuild

When a failure occurs during the log initialization phase or the current status rebuild phase of restart, you need to recover from this situation.

Symptoms

An abend was issued, indicating that restart failed. In addition, either the last restart message that was received was a DSNJ001I message that indicates a failure during current status rebuild, or none of the following messages was issued:

  • DSNJ001I
  • DSNR004I
  • DSNR005I

If none of the preceding messages was issued, the failure occurred during the log initialization phase of restart.

Environment

What happens in the environment depends on whether the failure occurred during log initialization or current status rebuild.

Failure during log initialization
Db2 terminates because a portion of the log is inaccessible, and Db2 cannot locate the end of the log during restart.
Failure during current status rebuild
Db2 terminates because a portion of the log is inaccessible, and Db2 cannot determine the state of the subsystem at the prior Db2 termination. Possible states include: outstanding units of recovery, outstanding database writes, and exception database conditions.

Resolving the problem

Operations management response:
To correct the problem, choose one of the following approaches:
  • Correct the problem that has made the log inaccessible, and start Db2 again. To determine if this approach is possible, read the relevant information about the messages and codes that you received. The explanations for the messages and codes identify the corrective action that can be taken to resolve the problem.
  • Restore the Db2 log and all data to a prior consistent point, and then start Db2. This procedure is described in Recovering from unresolvable BSDS or log data set problem during restart.
  • Start Db2 without completing some database changes. Using a combination of Db2 services and your own knowledge, determine what work is likely to be lost if you truncate the log. The procedure for determining the page sets that contain incomplete changes is described in Restarting Db2 by truncating the log.