Recovering from an error during RECOVER POSTPONED processing

When an error prevents logging of a compensation log record, Db2 terminates abnormally.

Procedure

If Db2 terminates abnormally:

  1. Fix the error.
  2. Restart Db2.
  3. Re-issue the RECOVER POSTPONED command if automatic backout processing has not been specified.

    If the RECOVER POSTPONED processing lasts for an extended period, the output includes DSNR047I messages to help you monitor backout processing. These messages show the current RBA that is being processed and the target RBA.