Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Copy for Db2 13.1.

Using the COPY INDEX specification

You can create index image copies by using the INDEX specification with the COPY command. In this case, the indexes specified are copied.

If the IXSIZE option is non-zero, only indexes that exceed IXSIZE are copied. For more information, see Copying-indexes-based-on-size.

COPY INDEX creatorID.indexName specifies the index to be copied. creatorID optionally specifies the creator of the index. The default is DSNDB04. The name of the index to be copied is specified by indexName.

BMC AMI Copy accepts delimited index names. Delimited index names are enclosed by double quotes (') and can contain special characters. A delimited name can be used when the sequence of characters does not qualify as an ordinary Db2 identifier. Such a sequence, for example, could be an SQL reserved word, or it could begin with a digit. Two consecutive escape characters are used to represent one escape character within the delimited name.

Important

When you use a delimited name for an index, you cannot use the wildcard feature of BMC AMI Copy.


Related topic

Creating-index-backups

 

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