Resolving an indoubt unit of recovery during Db2 restart

When Db2 logs are no longer available, you can resolve one, long-running indoubt unit of recovery (UR) during Db2 restart by using the CRESTART control statement of the DSNJU003 utility.

About this task

Use this method of resolving an indoubt UR only when the Db2 logs are not available. All database updates for the indoubt UR are committed after Db2 restarts.

Procedure

To resolve an indoubt UR during Db2 restart:

Run the DSNJU003 utility and specify the CRESTART control statement with the following options:
  • STARTRBA, where the value is the first log RBA that is available after the indoubt UR
  • FORWARD=YES to allow forward-log recovery
  • BACKOUT=YES to allow backward-log recovery