Information
Limited support BMC 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.

COPY syntax options


This section describes the options you can specify with the COPY command and the values you can specify for each option.

Your copy requirement determines which options you should include in a COPY statement.

COPY syntax options

GUID-EA159F77-C420-4E38-8BC9-C356DE9ACD1C-low.png

Option

Description

Object list

The Object List refers to the section of the COPY statement that tells BMC AMI Copy what table spaces and/or indexes you want to copy by specifying TABLESPACE, INDEXSPACE, INDEX, APPLICATION, RMGROUP (or RMGROUPTS), RMGROUPIX, or OBJECTSET.

The Object List must be the first specification made for the COPY command. RMGROUP, RMGROUPIX, or OBJECTSET, which specifies a BMC AMI Recovery Manager object set, can be used as an alternative to the TABLESPACE specification. Table spaces and indexes owned by an application, such as SAP R/3, can also be copied using BMC AMI Copy by specifying APPLICATION with a creator name, such as SAPR3. Multiple TABLESPACE, INDEXSPACE, INDEX, RMGROUP, RMGROUPIX, OBJECTSET, or APPLICATION keywords can be used with one COPY statement.

Object options

The Object Options refer to the section of the COPY statement that defines those options that apply to the specified table spaces or indexes.

The Object Options can be specified with different values for each table space and index space in your Object List and apply to the most previous TABLESPACE, INDEXSPACE, INDEX, RMGROUP, RMGROUPIX, OBJECTSET, or APPLICATION specification. The keywords in the Object Options can be used in any order (before you begin Global COPY Options).

Global COPY options

The Global COPY Options refer to the section of the COPY statement that defines those options that apply to the entire COPY statement and not to a specific TABLESPACE, INDEXSPACE, INDEX, RMGROUP, RMGROUPIX, OBJECTSET, or APPLICATION specification.

Global COPY Options can only be defined once for a single COPY command. Keywords in the Global COPY Options can be used in any order (after Object Options are specified).


 

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

BMC AMI Copy for Db2 12.1