Skip to Content

Default language.

Performance of an initial full migration

You can use the BMC AMI Recover for Db2 product to build the table spaces and index sets for the receiving Db2 subsystem by using image copies, change accumulation files, and logs made for recovery purposes on the sending (production) Db2 subsystem.

To create the decision-support database, you

  • Create the database, table spaces, tables, and primary indexes.

Related topic

Example-1-Ongoing-migration-with-adjusted-ranges

  • Establish a point of consistency.
  • Use the INDEPENDENT OUTSPACE and OBIDXLAT features of BMC AMI Recover to re-create the table spaces and primary indexes, and to translate object IDs.
  • Add the new indexes for the decision-support database by using DDL statements on the decision-support subsystem.

For many environments, the mass migration of data on a daily basis is time consuming and expensive. By using BMC AMI Log Master, you can migrate just the data changes, which is a convenient and quick way to update the decision-support database on an ongoing basis.

 

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

BMC AMI Log Master for Db2 13.1