Comparison of the BMC AMI Copy MODIFY command and the Db2 MODIFY RECOVERY utility


The following table shows comparison of Db2 MODIFY RECOVERY and the BMC AMI Copy MODIFY command perform several of the same functions and tasks. However, the BMC AMI Copy MODIFY command offers many additional capabilities.

Related topic

Function or task

Db2 MODIFY RECOVERY

BMC AMI Copy MODIFY command

Deletes records from the SYSCOPY table

x

x

Inserts records into the SYSCOPY table


x

Updates records in the SYSCOPY table


x

Verifies recoverability of copies in the SYSCOPY table


x

Deletes records according to age or date

x

x

Synchronizes the SYSCOPY table with the ICF catalog


x

Provides wildcard support for table space and index space names


x

Makes copies of unrecoverable spaces using BMC AMI Copy


x

Deletes records from the SYSLGRNX table

x

x

Provides flexible, SQL-like WHERE clause


x

Deletes records from the BMCXCOPY table


x

Inserts records into the BMCXCOPY table


x

Updates records in the BMCXCOPY table


x

Audits the amount of log since the last copy


x

Audits the number of days since the last copy


x

Deletes records based on a maximum number of copies


x

Controls the commit frequency


x

Allows specification of how to handle error processing for unacceptable status


x

Uses object sets defined in the BMC AMI Recovery Manager for Db2 product


x

Identifies application objects, such as SAP R/3 applications, as an alternative object specification


x

Supports Instant Snapshot copies


x

Optionally allows DELETE from SYSCOPY without setting COPY-pending status


x

Warning

Important

You define COPY YES for an index by executing ALTER INDEX or CREATE INDEX with the COPY YES parameter specified. When you use the COPY YES attribute, BMC AMI Copy registers the full index copies in SYSCOPY provided that you do not specify IXDSNUM DATASET.

All other index copies, as well as Instant Snapshot copies, are registered in the BMC table BMCXCOPY.

 

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

BMC AMI Copy for Db2 13.1