Determining which recovery base Db2 uses

The recovery base is the copy that the RECOVER utility starts with when recovering an object. RECOVER then applies logs as needed.

Procedure

To determine which recovery base Db2 uses:

Run the REPORT utility with the RECOVERY option. Review the output to determine whether the objects to be recovered have any of the following items:
  • Sequential image copies
  • Concurrent copies
  • FlashCopy® image copies
  • a utility LOG YES event

If you take system-level backups and the value of the SYSTEM_LEVEL_BACKUPS subsystem parameter is YES, also look at your system-level backup information in the BSDS to determine the recovery base.