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.

Copying indexes based on size

Use the following procedure to copy indexes based on size.

To determine a threshold for creating index image copies

Use the IXSIZE installation option.The IXSIZE value defines the smallest index data set that is copied. Other indexes are not copied even if they would have otherwise been selected. For more information, see IXSIZE=0.

The IXSIZE installation option can also be overridden at runtime by the IXSIZE parameter on the OPTIONS statement. Syntax for this option is defined on OPTIONS-syntax-option-description.

Example

In the following example any indexes defined on table space A.B are selected for the copy:

COPY TABLESPACE A.B
INDEXES
YES SHRLEVEL REFERENCE

However, if the IXSIZE option is used, either in the OPTIONS statement or in the ACP$OPTS installation options module, only indexes that exceed the threshold that it defines are copied:

OPTIONS IXSIZE 500M

COPY TABLESPACE A.B
INDEXES YES
SHRLEVEL REFERENCE

In this case, indexes defined on table space A.B will only be copied if they are at least 500 megabytes in size.

The IXSIZE threshold also applies to the COPY IMAGECOPY statement. The IXSIZE value used for COPY IMAGECOPY needs to match the value used for the COPY statement.

If you run COPY IMAGECOPY and the current index is smaller than the IXSIZE threshold, that index will be bypassed and BMC AMI Copy issues the following message:

BMC47414I COPY BYPASSED DUE TO 'IXSIZE' OPTION

You can specify IXSIZE 0 to run COPY IMAGECOPY on a small index.

Also, if BMC AMI Copy finds no index copy when you run COPY IMAGECOPY with an IXSIZE value specified, BMC AMI Copy issues the message given above and continues processing.

Important

The IXSIZE threshold is ignored if any output does not use dynamic allocation.

Related topic

Creating-index-backups

 

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