Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Using Online Consistent Copy for recovery


Use one of the following methods to recover using Instant Snapshot data sets created by Online Consistent Copy:

  • Use the RECOVER command available with the BMC AMI Recover for Db2 product. BMC AMI Recover automatically finds the Online Consistent Copies in BMCXCOPY and performs normal recovery operations using the copies, including forward log apply if required.

    Such recoveries have the advantage that you can very quickly recover one or more spaces to a previous consistent point in time without applying any log records. You might find this especially useful, for example, in some situations where you make a copy before you put a new version of an application into production and you want to be able to fall back to the copy quickly if there is a problem with the application.

  • Rename the Instant Snapshot data sets.
  • Use the DSN1COPY utility to restore the Db2 data sets from the Instant Snapshots.
  • Data sets produced by Online Consistent Copy are not recognized by the IBM RECOVER utility because they are registered in BMCXCOPY. However, you can use the COPY IMAGECOPY command available with the BMC AMI Copy product to create standard image copies that are registered in SYSCOPY. Then use the IBM RECOVER utility for normal forward recovery with the following restriction. If the table space uses LOCKSIZE ROW, the IBM RECOVER utility can use the copies only for a TOCOPY recovery. (This restriction does not apply to BMC AMI Recover.)

This section contains the following topics:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

Recovery Management for Db2 13.1