Recovering from a loss of dual active logging

If you use dual active logs, which is generally recommended, and one of the active log fails, Db2 reverts to use of a single active log. You can recover from this situation and return to dual active-log mode.

Symptoms

The following message is issued:

DSNJ004I - ACTIVE LOG COPY n INACTIVE, LOG IN SINGLE MODE,
       ENDRBA=...

Causes

This problem occurs when Db2 completes one active log data set and then finds that the subsequent copy (COPY n) data sets have not been offloaded and are marked STOPPED.

Environment

Db2 continues in single mode until offloading completes and then returns to dual mode. If the data set is marked STOPPED, however, intervention is required.

Resolving the problem

System programmer response:
  1. Verify that offload is proceeding and is not waiting for a tape mount. You might need to run the Db2 print log map utility (DSNJU004) to determine the status of all data sets.
  2. If any data sets are marked STOPPED, use IDCAMS to delete the data sets, and then re-add them by using the Db2 change log inventory utility (DSNJU003).