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.

COPY syntax rules

When you use the COPY command in the utility job input, these rules apply:

  • The first keyword you specify must be one of the following:
    • TABLESPACE
    • INDEXSPACE
    • INDEX
    • RMGROUP
    • RMGROUPIX
    • OBJECTSET
    • APPLICATION
  • You can specify keywords shown in the Object Options in COPY-command in any order. However, the order in which you specify the COPYDDN and RECOVERYDDN options might impact registration.
  • You can specify keywords shown in the Global COPY Options in COPY-command in any order.
  • If the Object List contains only INDEXSPACE or INDEX, Object Options or Global COPY Options that apply only to TABLESPACE cannot be specified. (An error results if they are used.) Options that apply only to TABLESPACE include:
    • CHECKERROR
    • CHECKTSLEVEL
    • DSNUM PART and DSNUM ALL
    • FULL and all of its suboptions
    • INDEXES
    • NACTIVE
    • RESETMOD
    • RUNSTATS
    • SQUEEZE
  • TABLESPACE, INDEXSPACE, INDEX, RMGROUP, RMGROUPIX, OBJECTSET, or APPLICATION keywords can be mixed within a COPY statement.
  • If the Object List contains TABLESPACE and INDEXSPACE or INDEX, you can specify options that apply to both table spaces and indexes. Options that apply only to table spaces are ignored for indexes, but a message will be issued.
  • If the COPY command contains a single TABLESPACE, INDEXSPACE, INDEX, RMGROUP, RMGROUPIX, OBJECTSET, or APPLICATION keyword, Object Options and Global COPY Options can be mixed in the COPY statement.
  • If the COPY command contains multiple TABLESPACE, INDEXSPACE, INDEX, RMGROUP, RMGROUPIX, OBJECTSET, or APPLICATION keywords, Global COPY Options must be coded last.
  • If you specify COPYDSN or RECOVERYDSN, they must be specified after the corresponding COPYDDN or RECOVERYDDN options.
  • You can specify a subordinate option only with the appropriate primary option (as shown in the preceding syntax diagram, COPY-command).
  • If you do not specify an option that is required during processing, BMC AMI Copy uses the default value of that option. In some cases, the default is the value of the corresponding installation option.
  • You cannot split a token, such as a keyword or identifier, across lines.
  • An asterisk in column 1 in the SYSIN data set specifies that the line is a comment that will not be echoed in the SYSPRINT output. A double hyphen (--) coded in column 1 through 70 also makes the rest of the line a comment.

  • A single COPY command can be followed by multiple TABLESPACE, INDEXSPACE, INDEX, RMGROUP, RMGROUPIX, OBJECTSET, or APPLICATION object list keywords. This also allows you to group and use a different value per object list keyword for the following options, which apply to the most recently specified object in a group:

    • BIGDDN
    • BIGDSN
    • BIGRECDDN
    • BIGRECDSN
    • COPYDDN
    • COPYDSN
    • DSNAME
    • DSNUM
    • EXCLUDE
    • FULLDDN
    • FULLDSN
    • FULLRECDDN
    • FULLRECDSN
    • INDEXES (applicable to TABLESPACE only)
    • RECOVERYDDN
    • RECOVERYDSN
    • TASK

    Only the global options can be specified for a group.

    You can use grouping without dynamic allocation by specifying different values for COPYDDN, DSNUM ALL or DSNUM integer, RECOVERYDDN, or TASK.

  • When copying multiple objects in a single copy statement, if you want to specify a different object option for one or more of the objects, you must use multiple object keywords (TABLESPACE, INDEXSPACE, INDEX, RMGROUP, RMGROUPIX, OBJECTSET, or APPLICATION) and include a complete list of object options for each object keyword. See Example-2-Making-copies-with-MAXTASKS.
  • The global COPY options listed below apply to the COPY command and should be specified only once per COPY command:
    • CHECKERROR (applicable to TABLESPACE only)
    • CHECKTSLEVEL (applicable to TABLESPACE only)
    • COMPRESS
    • FULL and CHANGELIMIT and any of their suboptions (applicable to TABLESPACE only)
    • GROUP and any of its suboptions
    • NACTIVE (applicable to TABLESPACE only)
    • ON ERROR BADSTATUS
    • ON ERROR NOTSUPPORTED
    • ON DUPLICATEDS
    • QUIESCE AFTER and suboption
    • QUIESCE BEFORE and suboption
    • PARALLEL
    • RESETMOD (applicable to TABLESPACE only)
    • RESYNC
    • RUNSTATS (applicable to TABLESPACE only)
    • SHRLEVEL
    • SQUEEZE (applicable to TABLESPACE only)

Related topics

COPY-command

Global-COPY-options

 

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