Skip to Content
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 migration

For the following reasons, database administrators often need to migrate data to another set of Db2 objects or to another Db2 subsystem:

  • Populating data on a reporting or analysis system.
  • Populating a test system.
  • Load balancing.
  • Loading a data warehouse.

Related topics

Status-considerations

Usage-scenarios

The standard ways to migrate data are to use the DSN1COPY utility or to UNLOAD the data into a temporary file and then LOAD it into the target objects. It is usually best if the data is consistent. Using standard utilities to make a consistent copy of the data requires an outage on the source tables—you must quiesce the source tables and restart them in read-only status. Because of this outage, the source tables are not available for read-write access for some period of time.

Online Consistent Copy allows you to make a consistent copy without any outage on the source objects.

In addition to the examples here, you can use the EXPORT option of BMC AMI Copy to create a migration file for OCCs and use the IMPORT option of BMC AMI Recover to import the copies on the target system.

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