UPDATE VERSIONS for IMPORT

The UPDATE VERSIONS option is useful if you migrate data from one Db2 system to another using BMC AMI Recover. BMC AMI Recover provides a fast way to restore a copy from the source system to the target system.

Related topic

IMPORT-command

If you use BMC AMI Recover and the UPDATE VERSIONS option to perform the migration, you need to:

  • Make sure that your copies contain system pages or directory pages for all versions of the space
  • Import table spaces in a separate step from rebuilding indexes
    You can recover indexes and table spaces in the same step, but rebuilds must be in a separate step.

After recovering a versioned table space, use UPDATE VERSIONS to call one of the following utilities:

  • REPAIR VERSIONS, for IBM Db2 versions earlier than 12.1.100
  • REPAIR CATALOG, for IBM Db2 Version 12.1.100 or later

The utilities check for and correct inconsistencies between the catalog and a table space or index. The utilities update the version information in the Db2 catalog and directory so that the source and target information match.

 

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