Using Online Consistent Copy

Online consistent copies, copies made without any outage and that are physically and transactionally consistent, are a feature of the BMC Recovery Management for Db2 solution and are registered in the BMCXCOPY table. These copies, which are used for recovery to copy, are also useful for migration. Recovery Management for Db2 introduces the use of online consistent copies and log apply for forward recovery.

Related topics

Using-Instant-Snapshots

BMCXCOPY-table


Important

Because the Online Consistent Copy feature is part of the Recovery Management for Db2 solution, making online consistent copies and using them for recovery requires use of a valid Recovery Management for Db2 solution password. For more information about Online Consistent Copy and Recovery Management for Db2, see Recovery Management for Db2 documentation.

BMC AMI Recover supports the use of online consistent copies and log apply for forward recovery to the current time or to a point in time, as well as recovery to a copy.

Important

Note the following considerations:

  • BMC AMI Recover supports online consistent copies with log apply when you do not specify INCOPY.
  • BMC AMI Recover supports online consistent copies with INCOPY TOCOPY specified.
  • BMC AMI Recover does not support online consistent copies when you specify both INCOPY and log apply (RBA or LOGPOINT specified in the INCOPY specification).

Extra processing is required to make online consistent copies and to recover using log applied to an online consistent copy, so you should make online consistent copies and use them for recovery only when doing so adds value to your processes, such as when there is a requirement for migration or recovery to a copy.

You can make online consistent copies on either snappable or nonsnappable storage. However, online consistent copies generally perform better when they are on snappable storage. If consistent copies are on nonsnappable storage, you need to specify the DATAMVR installation option (DATAMVR) or specify the DATAMVR option on the OPTIONS statement (DATAMVR-programName) to override the installation option. The DATAMVR option provides XBM with the name of the program to use to copy a data set.

If you request a RECOVER TOCOPY using an online consistent copy that is not available, the fallback recovery is a TIMESTAMP recovery.

Important

If you perform a RECOVER TOCOPY using an online consistent copy, you should make a new copy after the recovery completes. After the RECOVER TOCOPY, you will not be able to use copies made before the START_RBA of the online consistent copy.

 

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