Skip to Content

Registering index copies

Index copies are generally registered in SYSIBM.SYSCOPY when the copy would be usable by DSNUTILB for recovery:

  • Copies of indexes are registered in SYSIBM.SYSCOPY when all of the following conditions are met:
    • The index is defined with the COPY YES attribute.
    • The copy is made using IXDSNUM ALL.
    • The copy is made using FULL YES.
    • The copy is not encrypted.
    • The copy was not made using STACK CABINET.

Related topic

Creating-index-backups

  • In all other cases, copies of indexes are registered in the BMC-provided table, BMCXCOPY-table.

Incremental index copies are always registered in the BMXCOPY table (BMCXCOPY-table) with an ICTYPE of I or i. These copies are for use by other BMC products. Incremental index copies are not supported by the Db2 recover utility.

 

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

BMC AMI Copy for Db2 13.1