Using BACKOUT AUTO recovery

When you request a point-in-time recovery, using the BACKOUT strategy is desirable. However, there are some restrictions that prevent an object from being backed out. The BACKOUT to forward strategy performs a BACKOUT on all eligible objects and automatically schedules a forward recovery for the ineligible objects, as well as any other objects that failed in the BACKOUT recovery step.

The BACKOUT installation option (BACKOUT=AUTO) defaults to AUTO. With this installation option set to its default value, if you are using a Recovery Management for Db2 password, point-in-time recoveries automatically use the BACKOUT AUTO recovery strategy. If you are not using a Recovery Management for Db2 password, point-in-time recoveries use a standard forward recovery. You can also request the BACKOUT to forward recovery strategy using the BACKOUT AUTO option (BACKOUT) on the OPTIONS command in the JCL.

Important

BACKOUT to forward recovery is a feature of the Recovery Management for Db2 solution and the BACKOUT AUTO option requires the use of a valid Recovery Management for Db2 solution password. For more information about BACKOUT AUTO recovery and Recovery Management for Db2, see the Recovery Management for Db2 documentation Open link .

Comparing BACKOUT performance

Using BACKOUT

ON ERROR ANY CONTINUE integer or ON ERROR CONTINUE integer

Using BACKOUT AUTO recovery

Comments