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 IMAGECOPY syntax options


This section describes each of the options you can specify with the COPY IMAGECOPY command.

Option

Description

APPLICATION creatorName

APPLICATION creatorName can be used to specify the object for COPY IMAGECOPY. When this type of object is specified with a creator name of SAPR3, all table spaces that have CREATOR=SAPR3 are copied. If INDEXES YES is specified, the indexes for the selected table spaces are also copied.

APPLICATION can be mixed with TABLESPACE and INDEXSPACE specifications within the same COPY IMAGECOPY command.

ATLOGPOINT

The ATLOGPOINT option provides BMC AMI Copy with a start RBA value of the image copy you want to duplicate. The LRSN of the copy must be registered in the SYSIBM.SYSCOPY table or BMCXCOPY. The default is the most recent primary image copy registered.

ATLOGPOINT syntax diagram

3_ATLOGPOINT_syntax_diagram.png

Important

Use ATLOGPOINT in a data sharing environment; use ATRBA in a non-data-sharing environment.

Values of ATLOGPOINT

Value

Description

ATLOGPOINT LASTCOPY

When you want to duplicate the most recently registered primary image copy of the named space, use the default ATLOGPOINT LASTCOPY to specify the start RBA value of that image copy.

Important

If you code a COPY IMAGECOPY statement for the same table space or partition after a COPY statement in the same SYSIN data set, BMC AMI Copy interprets ATLOGPOINT LASTCOPY as the last copy registered by that COPY statement.

ATLOGPOINT LASTFULLCOPY

When you want to duplicate the most recently registered full image copy (ICTYPE F) of the named space, use ATLOGPOINT LASTFULLCOPY to specify the start RBA value of that image copy.

ATLOGPOINT LASTFLASHCOPY

When you want to duplicate the most recently registered flash copy (ICTYPE F) of the named space, use ATLOGPOINT LASTFLASHCOPY to specify the start RBA value of that image copy.

ATLOGPOINT LASTINCRCOPY

When you want to duplicate the most recently registered incremental (ICTYPE I) image copy of the named space, use ATLOGPOINT LASTINCRCOPY to specify the start RBA value of that image copy.

ATLOGPOINT X’hexStartLRSN’

Use ATLOGPOINT X’ hexStartLRSN’ to specify the start RBA of the image copy that you want to duplicate.

ATRBA

Important

Use ATRBA in a non-data-sharing environment; use ATLOGPOINT in a data sharing environment.

The ATRBA option provides BMC AMI Copy with the start RBA value of the image copy you want to duplicate. The RBA of the copy must be registered in the SYSIBM.SYSCOPY table or BMCXCOPY. The default is the most recent primary image copy registered.

Values of ATRBA

Value

Description

ATRBA LASTCOPY

When you want to duplicate the most recently registered primary image copy of the named table space, use the default ATRBA LASTCOPY to specify the RBA of that image copy.

Important

If you code a COPY IMAGECOPY statement for the same table space after a COPY statement in the same SYSIN data set, BMC AMI Copy interprets a specification of ATRBA LASTCOPY as the last copy registered by that COPY statement.

ATRBA LASTFULLCOPY

When you want to duplicate the most recently registered full image copy (ICTYPE F) of the named space, use ATRBA LASTFULLCOPY to specify the start RBA value of that image copy.

ATRBA LASTFLASHCOPY

When you want to duplicate the most recently registered flash copy (ICTYPE F) of the named space, use ATRBA LASTFLASHCOPY to specify the start RBA value of that image copy.

ATRBA LASTINCRCOPY

When you want to duplicate the most recently registered incremental (ICTYPE I) image copy of the named space, use ATRBA LASTINCRCOPY to specify the start RBA value of that image copy.

ATRBA X’hexStartRBA’

Use ATRBA X’ hexStartRBA’ to specify the start RBA value of the image copy that you want to duplicate.

AUX

The AUX option allows BMC AMI Copy to include auxiliary objects, history objects, and archive tables in the copy without having to explicitly specify these objects.

For a description of the AUX option and its parameters, see AUX.

CHECKERROR integer

Important

The CHECKERROR option does not apply to index copies.

The CHECKERROR integer option allows you to override the CHECKERR installation option that controls the severity of page checking errors. The value of integer is any integral number between 0 and 254 and is used by BMC AMI Copy as a condition code. A condition code of 4 or less allows execution to continue in the event of a page checking error; a code greater than 4 causes BMC AMI Copy to terminate at the point of the error.

Important

CHECKERROR is ignored for indexes if INDEXES YES is specified with the COPY IMAGECOPY command.

CHECKTSLEVEL

Important

The CHECKTSLEVEL option does not apply to index copies.

The CHECKTSLEVEL option identifies any damaged pages found during the copy process and ensures that all target pages have correct internal formats and can be used for table space recovery. CHECKTSLEVEL allows you to select the level and frequency of checking for a target table space. Page checking in this way provides better use of computer resources because the integrity checks are performed when copies are made, instead of during a separate pass using a stand-alone utility. This option does not check data content. Refer to CHECKLVL=0 for information about performance considerations.

If a problem occurs, BMC AMI Copy issues a warning message (BMC474xx) specifying the nature of the problem and, if applicable, the page number. The job completes with a condition code based on CHECKERROR or, if CHECKERROR is not specified, based on CHECKERR. For more information about BMC474xx messages, see to BMC-Common-Db2-repository.

If you do not specify CHECKTSLEVEL, the level of checking performed by BMC AMI Copy is determined by the current value of the CHECKLVL installation option as follows:

  • If CHECKLVL=0, the level of checking performed is the same as for CHECKTSLEVEL 0. CHECKLVL=0 is the installation option default.
  • If CHECKLVL=1, the level of checking performed is the same as for CHECKTSLEVEL 1.
  • If CHECKLVL=2, the level of checking performed is the same as for CHECKTSLEVEL 2.

Important

CHECKTSLEVEL is ignored for indexes if INDEXES YES is specified with the COPY IMAGECOPY command.

Values of CHECKSLEVEL

Value

Description

CHECKTSLEVEL 0

When you specify CHECKTSLEVEL 0, BMC AMI Copy provides standard minimal checking. Specifically, BMC AMI Copy checks the page number, broken page indicator, consistency of the header and trailer bytes, and validity of the page’s log RBA (or LRSN when the copy is made with Db2 in a data sharing environment).

CHECKTSLEVEL 1

When you specify CHECKTSLEVEL 1, BMC AMI Copy provides intrapage integrity checks for all pages (header pages, space map pages, and data pages). These are performed for both application table spaces and catalog and directory table spaces (except for special case catalog and directory spaces).

When you specify CHECKTSLEVEL 1, BMC AMI Copy performs the intrapage checks for the indicated page type as appropriate for the version of Db2 installed. See the following table "Interpage checks".

CHECKTSLEVEL 2

Important

CHECKTSLEVEL 2 is not valid for copying incremental copies.

When you specify CHECKTSLEVEL 2, BMC AMI Copy provides all of the intrapage integrity checks listed for CHECKTSLEVEL 1 and also performs interpage checks. These are performed for both application table spaces and catalog and directory table spaces (except for special case catalog and directory spaces).

When you specify CHECKTSLEVEL 2, BMC AMI Copy performs the following interpage checks:

  • Pointer records point to the correct overflow records.
  • Table segment chains are correct and all allocated segments are on one chain (and only one chain) for segmented table space.
  • HPGZNUMP agrees with the number of dictionary pages found.
  • If the header does not indicate the existence of a dictionary, no dictionary pages or compressed data records are found.
  • HPGSGSZ agrees with the SEGSIZE in the space map pages.
  • Dictionary pages are in the range indicated by the HPGZNUM and HPGZNUMP fields of the associated header page.

For table space map pages, BMC AMI Copy checks the consistency of:

  • SEGLENT values for segmented table spaces
  • FOSMLENT values for nonsegmented table spaces

When processing Db2 catalog and directory spaces, BMC AMI Copy also checks:

  • Hash chains in the directory
  • Ring pointer chains in the catalog to verify that the chains are intact

 Interpage checks

Page type

Interpage check

All page types

BMC AMI Copy checks the following fields for all types of page.

  • PGCOMB for consistency with the page trailer byte
  • PGNUMBER for the page number and partition value
  • PGFLAGS for the setting of the 'broken' bit
  • PGFLAGS for the correct setting for the type of page

Header pages

For header pages BMC AMI Copy checks the following items for agreement with values in the Db2 catalog:

  • BMC AMI Copy also verifies that the header page fields HPGCLRSN, HPGLEVEL, and HPGPLEVL are within the current log range of the Db2 subsystem.

    HPGPARTN (the number of partitions registered)

  • HPGPGSZ (the page size registered)
  • HPGVCATN (the VCAT name registered)
  • HPGDBID and HPGPSID

Also, for header pages, BMC AMI Copy verifies the following items:

  • HPGZPNUM and HPGZNUMP values are both zero or nonzero.
  • HPGSSNM matches the Db2 subsystem name.
  • HPGSGSZ is a valid segment size.
  • HPGRBRBA and HPGTORBA values are both within the current log range of the Db2 subsystem.

BMC AMI Copy also verifies that the header page fields HPGCLRSN, HPGLEVEL, and HPGPLEVL are within the current log range of the Db2 subsystem.

Table space map pages

For table space map pages, BMC AMI Copy verifies the following items:

  • FOSMNENT values are consistent for nonsegmented table spaces.
  • SEGNUM values are consistent for segmented table spaces.
  • SEGSIZE values are consistent for segmented table spaces.
  • SEGFREE values are consistent for segmented table spaces.
  • SEGENT values are consistent for segmented table spaces.
  • SEGOBID and SEGFLAG values are correct for each segment entry for segmented table spaces.

Data pages

For data pages, BMC AMI Copy verifies the following items:

  • The ID map entries and the ID map free chain are correct.
  • The large hole chains are correct.
  • The length and offset for each row or hole are correct.
  • PGFREE and PGFREEP values are correct.
  • PGMAXID values are correct.
  • The rows per page are within the maximum allowed.
  • Whether the page is a dictionary page.
  • No dictionary pages exist in catalog or directory spaces.
  • Whether the records are compressed.
  • No compressed records exist in catalog or directory spaces.
  • The PGSFLAGS record header flags are correct.

CLONE

The CLONE option indicates that COPY IMAGECOPY is to process only image copies that are for clone tables or indexes on clone tables.

The base table space and its clone can not be processed in the same BMC AMI Copy command.

COMPRESS

The COMPRESS option allows you to override the COMPRESS installation option that tells BMC AMI Copy whether to compress disk image copies. This option provides synergy with the BMC PACLOG utility by using the BMC Extended Compression Architecture (XCA) technology. The compressed disk image copies can be used by the IBM Db2 RECOVER and DSN1COPY utilities and the BMC AMI Recover and UNLOAD PLUS utilities. This option can also be set with the OPTIONS command (see OPTIONS-command). Also, see  and SQUEEZE for further compression information.

Warning

Always use COMPRESS NO when you have DASD hardware compression enabled.

To enable compression, the PACLOG load library must be in the BMC AMI Copy STEPLIB or JOBLIB. For more details, see the PACLOG for DB2 documentation.

If you do not specify COMPRESS in the COPY IMAGECOPY command, BMC AMI Copy uses the value of the COMPRESS installation option as the default.

Values of COMPRESS

Value

Description

COMPRESS YES

Specifying COMPRESS YES tells BMC AMI Copy to compress disk image copies. COMPRESS YES can be used in conjunction with the SQUEEZE YES of the COPY and COPY IMAGECOPY commands for additional savings.

If COMPRESS YES is specified but the compression libraries are not available or there is a problem registering the data set, a warning is issued and the copy continues without compression.

If COMPRESS YES is specified and the data set being copied is on tape, an informational message is issued to indicate that compression will not be invoked.

COMPRESS NO

Specifying COMPRESS NO tells BMC AMI Copy not to use compression for disk image copies.

COPYDDN

Use the COPYDDN option to tell BMC AMI Copy what additional local site copies of the space or partition should be made and where the corresponding data set names can be found.

COPYDDN syntax diagram

GUID-545650B3-06FC-416A-814E-9977A6F84D2F-low.png

If you allocate the copy data sets in the JCL, COPYDDN specifies the JCL data set definition names (DDNames). If you dynamically allocate the copy data sets, COPYDDN specifies the appropriate output descriptor names. If you want, you can name both a DDName and an output descriptor in the same COPYDDN clause.

Important

The following conditions apply to COPYDDN:

  • COPYDDN is not required; however, if you do not specify COPYDDN, you must specify RECOVERYDDN.
  • Copies made using COPY IMAGECOPY are automatically registered in SYSIBM.SYSCOPY or BMCXCOPY.

When you allocate copy data sets in the JCL, the COPYDDN option specifies the DDNames (DDName1, DDName2) to be used for making any required local site copies. Each DDName must be unique within the job step.

When you dynamically allocate the copy data sets, the COPYDDN option specifies the names of the output descriptors you want to use to provide the copy data sets. You can use the same output descriptor for both copies if you are not stacking copies to tape. When you stack both copies to tape, you must use a different output descriptor for each type of copy. (Refer to Stacking-copies-on-tape and Using-multitasking-with-tape-stacking-or-cabinet-copies for more information.)

You can override the default data set names named in the descriptor by using the DSNAME option or the COPYDSN option. Refer to COPY IMAGECOPY syntax options#DSNAME dataSetName and COPYDSN .

Proceed as follows to specify either one or two copies using COPYDDN:

  • Specify either COPYDDN(DDName1) or COPYDDN(outputDescriptor) to make a local site primary copy. This is valid only at a site where no local site primary copy is registered, except in the condition explained in the note below. Also, a remote primary copy must be registered already in SYSIBM.SYSCOPY or BMCXCOPY with the same RBA or LRSN values given with the ATRBA option or the ATLOGPOINT option, respectively.

    If neither a DDName nor an output descriptor is specified, no local primary copy is made. No default exists.

  • Specify either COPYDDN(, DDName2) or COPYDDN(, outputDescriptor) to make a local site backup copy. A local site primary copy must be registered already in SYSIBM.SYSCOPY or BMCXCOPY with the same RBA or LRSN values given with the ATRBA option or the ATLOGPOINT option, respectively. Also, no local site backup copy must be registered already, except in the condition explained in the note below.
  • Specify either COPYDDN(DDName1, DDName2) or COPYDDN(outputDescriptor, outputDescriptor) to make both local site primary and backup copies. Neither copy must be registered already in SYSIBM.SYSCOPY or BMCXCOPY, except in the condition explained in the note below. However, a remote site primary copy must be registered already with the same RBA or LRSN values given with the ATRBA option or the ATLOGPOINT option, respectively.

Important

If you specify the creation of an image copy, and that type (LP, LB, RP, RB) already exists as an Instant Snapshot copy, BMC AMI Copy allows the new image copy to be created. If no backup copy exists for the specified type, BMC AMI Copy changes the ICBACKUP value for the Instant Snapshot copy to the appropriate backup type (LB or RB). If a backup copy already exists or is being created in the same COPY IMAGECOPY execution, BMC AMI Copy deletes the row in BMCXCOPY that represents the Instant Snapshot copy.

COPYDSN

Use the COPYDSN option when you dynamically allocate the copy data sets and want to override the default copy data set names for the local site primary copy and/or the local site backup copy. COPYDSN is only valid after you have specified a copy data set output descriptor with COPYDDN.

COPYDSN syntax diagram
GUID-EB6C7FC8-AD7A-4150-AB40-87908F08982E-low.png

Proceed as follows:

  • To override only the local primary name, specify COPYDSN(dataSetName1).
  • To override only the local backup name, specify COPYDSN(, dataSetName2).
  • To override both, specify COPYDSN(dataSetName1, dataSetName2).

dataSetName1 and dataSetName2 are the new data set names. You can construct them using the symbolic variables described in Using-symbolic-variables.

DSNAME dataSetName

Use the DSNAME option when you dynamically allocate the copy data sets and want to override the default names for both the local site and recovery site copy data sets. The value of dataSetName becomes the new default data set name for all output copies; that is, when you use DSNAME, you need not specify either COPYDSN or RECOVERYDSN.

You can construct dataSetName using any of the symbolic variables listed under COPYDSN .

This option is usually used with wildcard selection of data sets.

For more information, see COPY-IMAGECOPY-command, Using-symbolic-variables, and Stacking-copies-on-tape.

DSNUM

For table space backup, the DSNUM option identifies either a single partition or data set in the table space named in the TABLESPACE option, or all of the partitions or data sets contained in that table space.

DSNUM syntax diagram

GUID-A9D712BD-16B0-47FF-BF9A-35CEDA4643FD-low.png

Important

* DSNUM is not applicable to RMGROUP or OBJECTSET objects.

 The default is all of the partitions or data sets (DSNUM ALL). The DSNUM value that you use in a COPY IMAGECOPY statement must be compatible with the value you use for making the original copy. For example, if you made the original copy of a partitioned table space using DSNUM ALL, you cannot use DSNUM PART in the COPY IMAGECOPY statement.

For index backup, BMC AMI Copy uses the value of DSNUM along with the setting of the IXDSNUM installation option to determine how index copies are handled. See IXDSNUM=ALL for details. You can override the IXDSNUM installation option at runtime by specifying IXDSNUM on the OPTIONS statement (see IXDSNUM).

For Instant Snapshot copies, see DSNUM-and-Instant-Snapshots.

For FlashCopies, see the information in DSNUM DATASET.

Values of DSNUM

Value

Description

DSNUM integer

For a table space, DSNUM integer is the number of a single data set or partition in the named table space or index space. For a partitioned space, integer is the partition number. For a nonpartitioned space, integer is the ordinal number of the data set for the table space. Specify this option to make backup and/or recovery site copies of a primary copy of the partition or data set.

Important

A standard Db2 copy of an Instant Snapshot primary copy from a multi-data-set, nonpartitioned table space requires Instant Snapshot primary copies of the other data sets of the space copies to be registered at the same RBA (LRSN).

For an index space, the value of integer must be in the range 1 through 4096. integer is the ordinal number of the data set for the table space.

Important

The IXDSNUM option influences how BMC AMI Copy makes index copies and works in conjunction with the value of DSNUM. For the effect of DSNUM integer on index copies using either COPY TABLESPACE ... INDEXES YES or COPY INDEXSPACE, see the IXDSNUM option description on IXDSNUM or IXDSNUM=ALL.

DSNUM begin:end

DSNUM begin : end specifies a range of partitions to process. You specify the range of partitions with two numbers separated by a colon (:) with or without spaces. The following example gives a specification that copies physical partitions 10 through 20:

    COPY TABLESPACE ACCOUNTS.*
    DSNUM 10:20

During the table space selection process, only partitioned table spaces that overlap the partition range qualify for selection. Nonpartitioned and partitioned table spaces that do not have as many partitions as the low value of the range do not qualify for selection, and BMC AMI Copy issues the following message:


GUID-A9D712BD-16B0-47FF-BF9A-35CEDA4643FD-low.png

 BMC47431I databaseName.tableSpaceName DID NOT QUALIFY FOR RANGE SELECTION

When you use the INDEXES YES option on the COPY command, the index space that is associated with the table space is also selected.

LOGICAL

Adding the LOGICAL option after a DSNUM begin: end specification allows you to indicate logical partitions rather than physical partitions and have the logical partitions mapped to their respective physical data set numbers. BMC AMI Copy then continues as if you specified a physical range of partitions. You might use the LOGICAL option if you have rotated your partitioned table spaces to create a logical view of the physical data sets.

In the following specification, the logical partition numbers 10 through 20 are mapped to their respective physical data set numbers:

     COPY TABLESPACE ACCOUNT.*
     DSNUM 10:20 LOGICAL

For INDEXES YES, COPY INDEXSPACE, and COPY INDEX, the conversion of the logical partition to the physical partitions is based on the parent table space.

DSNUM ALL

DSNUM ALL is the default and specifies that you want to make backup or recovery site copies of a primary copy of all of the partitions or data sets in the named table space.

Important

The IXDSNUM option influences how BMC AMI Copy makes index copies and works in conjunction with the value of DSNUM. For the effect of DSNUM ALL on index copies using either COPY TABLESPACE ... INDEXES YES or COPY INDEXSPACE, see the IXDSNUM option description on IXDSNUM or IXDSNUM=ALL.

DSNUM PART

Specify DSNUM PART when you want to make backup or recovery site copies of a primary copy of a partitioned table space that was made and registered by partition instead of by table space. In contrast, DSNUM ALL copies and registers a partitioned table space as one space.

When you use wildcard selection of table spaces with some partitioned and others nonpartitioned, specifying DSNUM PART provides copies by partition or by table space, as appropriate.

Important

The IXDSNUM option influences how BMC AMI Copy makes index copies and works in conjunction with the value of DSNUM. For the effect of DSNUM PART on index copies using either COPY TABLESPACE ... INDEXES YES or COPY INDEXSPACE, see the IXDSNUM option description IXDSNUM or IXDSNUM=ALL.

DSNUM DATASET

DSNUM DATASET specifies that you want to copy all physical data sets of the target index space as separate output data sets. DSNUM DATASET is similar to DSNUM PART except that nonpartitioned spaces are copied by data set.

Because FlashCopies are copied by data set, you should use DSNUM DATASET for COPY IMAGECOPY when the copy set may include FlashCopies or Snapshots. This situation might occur when you use wildcards to specify spaces for COPY IMAGECOPY and the wildcards include spaces that were copied with FlashCopy.

Important

The IXDSNUM option influences how BMC AMI Copy makes index copies and works in conjunction with the value of DSNUM. For the effect of DSNUM DATASET on index copies using either COPY TABLESPACE ... INDEXES YES or COPY INDEXSPACE, see the IXDSNUM option description on IXDSNUM or IXDSNUM=ALL.

EXCLUDE

Use the EXCLUDE option after a wildcard space specification to exclude one or more spaces from copying that would otherwise be copied. You can use wildcards % and * or specific names to specify the exclusions.

EXCLUDE syntax diagram

GUID-3768BD2F-BD71-47DC-BF52-4313AC0C9E20-low.png

The excluded spaces must be in the form of a list following the EXCLUDE keyword. Each item in the list must be in the form databaseName.s paceName and you must separate the individual items by commas. Optionally, you can enclose the list in parentheses. Excluding-specified-spaces-from-a-wildcard-specification provides more information.

Important

EXCLUDE processing is done in two passes. The first pass excludes table spaces from the table space list so that indexes for the excluded table spaces are not copied if INDEXES YES (see INDEXES) is specified. A second EXCLUDE pass is done after INDEXES YES is expanded so that indexes can be excluded by name.

INDEXES

The INDEXES option allows you to specify that you want BMC AMI Copy to make copies of the index copies associated with the table space copies given by the TABLESPACE option of the COPY IMAGECOPY command. The default is INDEXES NO indicating that no copies of the index copies are to be made.

Important

The use of INDEX is synonymous to INDEXES for this option.

The INDEXES option is not applicable to INDEXSPACE or INDEX specifications.

Values of INDEXES

Value

Description

INDEXES YES

Specifying INDEXES YES tells BMC AMI Copy to make copies of all index copies for the table space(s) specified by the TABLESPACE, APPLICATION, RMGROUP, or RMGROUPIX option. Dynamic allocation is required since only one COPYDDN or RECOVERYDDN can be specified.

Important

INDEXES YES is invalid with an unqualified OBJECTSET specification (OBJECTSET without TABLESPACE).

When INDEXES YES is specified with the COPY IMAGECOPY command, the TABLESPACE options specified are used, except for CHECKTSLEVEL, CHECKERROR, and SQUEEZE, which will be ignored.

If INDEXES YES is specified with a TABLESPACE option that has DSNUM specified, the value of the IXDSNUM installation option works with the value of DSNUM to determine how BMC AMI Copy makes the index copies. See the IXDSNUM description on IXDSNUM=ALL for details. The IXDSNUM installation option can be overridden at runtime by specifying IXDSNUM on the OPTIONS command (see IXDSNUM).

Important

When INDEXES YES is used with TABLESPACE, an index will be included only once within the same SYSIN. If you need to copy it more than once, you must use an INDEXSPACE keyword and the index name or create the copy in a separate step.

INDEXES NO

Specifying INDEXES NO tells BMC AMI Copy that no copies of the index copies for the specified table space or table spaces are to be made.

INDEX creatorID.indexName

Use the INDEX option to specify the indexes for which you want to make additional copies. The index specification is a list that can contain both explicit index names and wildcard patterns with the individual items in the list separated by commas. When you use a wildcard specification, you can also use the EXCLUDE option to specify any indexes you want to exclude from the copy. Also, when you use multiple index names in a single list, whether explicitly or by wildcard, you must use dynamic allocation.

Each explicit index in the list must be in the form creatorID.indexName where:

  • creatorID is the 8-character creator of the index. If you do not provide a creator ID, BMC AMI Copy uses the default, DSNDB04.
  • indexName is the 18-character name of the index to be copied.

Important

BMC AMI Copy supports longer names for indexes. Both creatorID and indexName have a maximum length of 128 characters. When you specify the name, do not use any blanks in the name, even if it extends onto a second line.

You can enclose creatorID.indexName in double quotation marks or single quotation marks. This allows use of special characters, such as $, #, or /, in your object names.

When you use a wildcard pattern to specify multiple indexes, you can include the wildcard characters * (asterisk) and % (percent) to provide matching on one or more characters. Using-wildcard-characters-in-the-object-name-specification tells you how wildcards are used and how BMC AMI Copy orders the results of wildcard expansions.

Important

The following conditions apply to the use of wildcards:

  • When you use * or % as wildcards to specify multiple indexes, BMC AMI Copy excludes indexes with a creator ID of SYSIBM to avoid unintentional copying of catalog, directory, and temporary databases.
  • If delimiters are used, BMC AMI Copy wildcards cannot be used.
  • If the wild card pattern results in no matches, BMC AMI Copy will issue a warning.

INDEX OBJECTSET objectSetName

Use INDEX OBJECTSET to specify the indexes that are included in a BMC AMI Recovery Manager object set for which you want to make additional copies. The BMC AMI Recovery Manager object set is identified by objectSetName. BMC AMI Copy expands the indexes for the objectSetName  into the appropriate index names and copies them.

objectSetName can have zero to any number of dot (.) separators.

BMC AMI Copy does not allow wildcards to be specified with OBJECTSET and will issue messages regarding an invalid group name if wildcards are used.

BMC AMI Copy accesses the BMC Common Db2 repository and the Db2 catalog to retrieve the table spaces that are defined for the group.

For more information about BMC AMI Recovery Manager object sets, see the BMC AMI Recovery Manager for Db2 documentation .

INDEXSPACE OBJECTSET objectSetName

Use INDEXSPACE OBJECTSET objectSetName to specify the index spaces that are included in a BMC AMI Recovery Manager object set for which you want to make additional copies. The BMC AMI Recovery Manager object set is identified by objectSetName. Each original must be an existing registered local site primary copy or a registered recovery site primary copy. If the allocation of the primary copy fails, BMC AMI Copy will attempt to use the backup copy as input if it exists.

BMC AMI Copy does not allow wildcards to be specified with OBJECTSET and will issue messages regarding an invalid group name if wildcards are used.

BMC AMI Copy accesses the BMC Common Db2 repository and the Db2 catalog to retrieve the table spaces that are defined for the group.

For more information about BMC AMI Recovery Manager object sets, see the BMC AMI Recovery Manager for Db2 documentation .

Important

Only the index spaces are used from a BMC AMI Recovery Manager object set. Any table spaces that appear in the group are ignored.

DSNUM cannot be specified with INDEXSPACE OBJECTSET. Object set objects are copied using the DSNUM specified in the BMC AMI Recovery Manager object set. However, EXCLUDE is supported.

OBJECTSET objectSetName

Use OBJECTSET objectSetName to specify the table spaces and index spaces that are included in a BMC AMI Recovery Manager object set for which you want to make additional copies. The BMC AMI Recovery Manager object set identified by objectSetName.

BMC AMI Copy does not allow wildcards to be specified with OBJECTSET and will issue messages regarding an invalid group name if wildcards are used.

BMC AMI Copy accesses the BMC Common Db2 repository and the Db2 catalog to retrieve the table spaces that are defined for the group.

For more information about BMC AMI Recovery Manager object sets, see the BMC AMI Recovery Manager for Db2 documentation.

ON ERROR ICEXISTS

The ON ERROR ICEXISTS option allows you to specify what action BMC AMI Copy is to take for COPY IMAGECOPY when the image copy to be created already exists or a valid source copy does not exist.

Values of ON ERROR EXISTS

Value

Description

ON ERROR ICEXISTS END

ON ERROR ICEXISTS END, the default, indicates BMC AMI Copy is to terminate processing.

ON ERROR ICEXISTS SKIP

ON ERROR ICEXISTS SKIP directs BMC AMI Copy to issue the message BMC30143I CONTINUING DUE TO ON ERROR ICEXISTS OPTION, skip the space, and continue processing the other spaces specified in SYSIN.

If you are making multiple output copies and all exist and you specified ON ERROR ICEXISTS SKIP, BMC AMI Copy issues an error message, but continues on to the next space, if there are any. If one or more copies exist, but one or more output copies have not been made, COPYPLUS issues an error message, skips over the spaces represented in the existing copies and continues processing to make the other copies that have not yet been made for spaces in the SYSIN list.

ON ERROR NOTSUPPORTED

The ON ERROR NOTSUPPORTED option allows you to specify what action BMC AMI Copy is to take if a space or partition is an unsupported type in BMC AMI Copy. The following table lists the types not supported by BMC AMI Copy and the error messages that BMC AMI Copy issues:


ON ERROR NOTSUPPORTED condition

BMC AMI Copy message issued

A space has a page size or piece size that is not supported.

BMC30575E PAGESIZE = pageSizeValue IS NOT SUPPORTED

Values of ON ERROR NOTSUPPORTED

Value

Description

ON ERROR NOTSUPPORTED END

ON ERROR NOSUPPORTED END, the default, indicates BMC AMI Copy is to terminate processing with a RC=12 if an unsupported type is encountered.

ON ERROR NOTSUPPORTED SKIP

ON ERROR NOTSUPPORTED SKIP causes BMC AMI Copy to issue a message, skip over the space, and continue processing other spaces specified in SYSIN.

RECOVERYDDN

Use the RECOVERYDDN option to tell BMC AMI Copy what additional recovery site copies of the space or partition should be made and where the corresponding data set names can be found.

RECOVERYDDN syntax diagram

GUID-31AFBE1B-A1D7-419D-990C-0E0400E5882D-low.png

If you allocate the copy data sets in the JCL, RECOVERYDDN specifies the JCL data set definition names (DDNames). If you dynamically allocate the copy data sets, RECOVERYDDN specifies the appropriate output descriptor names. If you want, you can name both a DDName and an output descriptor in the same RECOVERYDDN clause.

Important

RECOVERYDDN is not required; however, if you do not specify RECOVERYDDN, you must specify COPYDDN.

When you allocate copy data sets in the JCL, the RECOVERYDDN option specifies the DDNames (DDName3, DDName4) to be used for making recovery site copies. Each DDName must be unique within the job step.

When you dynamically allocate the copy data sets, the RECOVERYDDN option specifies the names of the output descriptors that you want to use to provide the copy data sets. You can use the same output descriptor for both copies if you are not stacking copies to tape. When you stack both copies to tape you must use a different output descriptor for each type of copy. (Refer to Stacking-copies-on-tape and Using-multitasking-with-tape-stacking-or-cabinet-copies for more information.)

You can override the default data set names named in the descriptor by using the DSNAME option or the RECOVERYDSN option. You can override other descriptor default parameters by using an OUTPUT statement. Refer to DSNAME dataSetName and RECOVERYDSN.

Proceed as follows to specify either one or two copies using RECOVERYDDN:

  • Specify either RECOVERYDDN(DDName3) or RECOVERYDDN(outputDescriptor) to make a recovery site primary copy. This is valid only at a site where no recovery site primary copy is already registered, except in the condition explained in the note below. There must be a local primary copy already registered in SYSIBM.SYSCOPY or BMCXCOPY with the same RBA or LRSN values given with the ATRBA option or the ATLOGPOINT option, respectively.

    If you specify neither a DDName nor an output descriptor, no recovery site primary copy is made.

  • Specify either RECOVERYDDN(, DDname4) or RECOVERYDDN(, outputDescriptor) to make a recovery site backup copy. This is valid only when a recovery site primary copy is already registered in SYSIBM.SYSCOPY or BMCXCOPY with the same RBA or LRSN values given with the ATRBA option or the ATLOGPOINT option, respectively. Also, no recovery site backup copy should be already registered, except in the condition explained in the note below.
  • Specify either RECOVERYDDN(DDName3, DDName4) or RECOVERYDDN(outputDescriptor, outputDescriptor) to make both recovery site primary and backup copies. Neither copy can be registered already in SYSIBM.SYSCOPY or BMCXCOPY, except in the condition explained in the note below. However, a local site primary copy must be registered already with the same RBA or LRSN values given with the ATRBA option or the ATLOGPOINT option, respectively.

Important

If you specify the creation of an image copy, and that type (LP, LB, RP, RB) already exists as an Instant Snapshot copy, BMC AMI Copy allows the new image copy to be created. If no backup copy exists for the specified type, BMC AMI Copy changes the ICBACKUP value for the Instant Snapshot copy to the appropriate backup type (LB or RB). If a backup copy already exists or is being created in the same COPY IMAGECOPY execution, BMC AMI Copy deletes the row in BMCXCOPY that represents the Instant Snapshot copy.

Copies you make using COPY IMAGECOPY are automatically registered in SYSIBM.SYSCOPY or BMCXCOPY.

RECOVERYDSN

Use the RECOVERYDSN option when you dynamically allocate the copy data sets and want to override the default copy data set names for the recovery site primary copy and/or the recovery site backup copy. RECOVERYDSN is valid only after you have specified a copy data set output descriptor with RECOVERYDDN.

RECOVERYDSN syntax diagram

GUID-5F704457-142E-4228-A922-1FA4E39A6DAD-low.png

Proceed as follows:

  • Specify RECOVERYDSN(dataSetName3) to override only the recovery primary name.
  • Specify RECOVERYDSN(, dataSetName4) to override only the recovery backup name.
  • Specify RECOVERYDSN(dataSetName3, dataSetName4) to override both.

dataSetName3 and dataSetName4 are the new data set names. You can construct them using any of the symbolic variables listed under COPYDSN .

RMGROUP creator.groupName RMGROUPTS creator.groupName

RMGROUP can be used in place of TABLESPACE in any COPY IMAGECOPY command. Use RMGROUP to specify the table spaces that are included in a BMC AMI Recovery Manager object set for which you want to make additional copies.

Important

COPY IMAGECOPY RMGROUPTS, COPY IMAGECOPY RMGROUP, and COPY IMAGECOPY TABLESPACE OBJECTSET are synonymous.

RMGROUP is followed by the two-part BMC AMI Recovery Manager creator.objectSetName. A maximum of 8 characters can be used for creator, while objectSetName can be a maximum of 18 characters. creator follows the rules for short SQL identifiers. objectSetName follows the rules for long SQL identifiers. Each part, creator and objectSetName, can be delimited by double or single quotation marks. The symbols $, #, and @ are valid and can be used as the first character for creator.

BMC AMI Copy does not allow wildcards to be specified with RMGROUP and will issue messages regarding an invalid group name if wildcards are used.

BMC AMI Copy accesses the BMC Common Db2 repository and the Db2 catalog to retrieve the table spaces that are defined for the group.

Important

DSNUM cannot be used with RMGROUP or RMGROUPIX. The DSNUM used for each object is its DSNUM in the BMC AMI Recovery Manager object set. However, EXCLUDE is supported with RMGROUP and RMGROUPIX.

For more information about BMC AMI Recovery Manager object sets, see the BMC AMI Recovery Manager for Db2 documentation .

Important

Only the table spaces are used from a BMC AMI Recovery Manager object set. Any index spaces that appear in the object set are ignored. The INDEXES YES option, the RMGROUPIX option, or the INDEX OBJECTSET option can be used to copy indexes for the selected table spaces. Also note, that DSNUM cannot be specified with RMGROUP. Group objects are copied using the DSNUM specified in the BMC AMI Recovery Manager object set. However, EXCLUDE is supported.

RMGROUPIX creator.groupName

Use RMGROUPIX to specify the index spaces that are included in a BMC AMI Recovery Manager object set for which you want additional copies. BMC AMI Copy expands the indexes for the creator.groupName into the appropriate index space names and makes the copy.

Important

DSNUM cannot be specified with RMGROUPIX. RMGROUPIX objects are copied using the DSNUM specified in the BMC AMI Recovery Manager object set. However, EXCLUDE is supported.

RMGROUPIX is followed by the two-part BMC AMI Recovery Manager creator.objectSetName. A maximum of 8 characters can be used for creator, while objectSetName can be a maximum of 18 characters. creator follows the rules for short SQL identifiers. objectSetName follows the rules for long SQL identifiers. Each part, creator and objectSetName, can be delimited by double or single quotation marks. The symbols $, #, and @ are valid and can be used as the first character for creator.

BMC AMI Copy does not allow wildcards to be specified with RMGROUPIX and will issue messages regarding an invalid group name if wildcards are used.

BMC AMI Copy accesses the BMC Common Db2 repository and the Db2 catalog to retrieve the table spaces that are defined for the group.

For more information about BMC AMI Recovery Manager object sets, see the BMC AMI Recovery Manager for Db2 documentation.

Important

Use RMGROUP or RMGROUPTS to copy the table spaces for a BMC AMI Recovery Manager object set.

SQUEEZE

Important

The SQUEEZE option does not apply to index copies.

The SQUEEZE option specifies to BMC AMI Copy whether to consolidate the rows on a table space page so that all of the free space on the page is contiguous. This consolidation enables more effective data compression (whether accomplished by software or by hardware) by decreasing the media space required for copy data sets. Row-consolidation-SQUEEZE provides more information about media space savings; also, see COMPRESS for other information about compressing copy data sets.

If you do not specify SQUEEZE, BMC AMI Copy uses the value of the SQUEEZE installation option as the default.

Important

SQUEEZE is ignored for indexes if INDEXES YES is specified with the COPY IMAGECOPY command

Values of SQUEEZE

Value

Description

SQUEEZE YES

SQUEEZE YES specifies that table space rows be consolidated on the copy.

SQUEEZE NO

SQUEEZE NO specifies that table space rows are not to be consolidated.

TABLESPACE databaseName.spaceName or INDEXSPACE databaseName.spaceName

Use the TABLESPACE or INDEXSPACE option to specify the spaces for which you want to make additional copies. Each original must be an existing registered local site primary copy or a registered recovery site primary copy. If the allocation of the primary copy fails, BMC AMI Copy will attempt to use the backup copy as input if it exists.

The space specification is a list that can contain both explicit space names and wildcard patterns with the individual items in the list separated by commas. When you use a wildcard specification, you can also use the EXCLUDE option to specify any spaces you want to exclude from the copy.

When you use multiple space names in a single list, whether explicitly or by wildcard, you must use dynamic allocation.

Important

BMC AMI Copy will order the processing based on the stacked tape ordering of the input copies if dynamic allocation is used.

Each explicit space name in the space list must be in the form databaseName.spaceName where:

  • databaseName is the name of the database containing the space. If you do not provide a database name, BMC AMI Copy uses the default DSNDB04.
  • spaceName is the name of the space containing the partitions or data sets for which the additional copies will be made.

You can enclosedatabaseName.spaceName in double quotation marks or single quotation marks. This allows use of special characters, such as $, #, or /, in your object names.

When you use a wildcard pattern to specify multiple spaces, you can include the wildcard characters * (asterisk) and % (percent) to provide matching on one or more characters. Using-wildcard-characters-in-the-object-name-specification tells you how wildcards are used and how BMC AMI Copy orders the results of wildcard expansions.

You can also use the DB2CATALOG wildcard to specify the copying of image copies of Db2 catalog and directory spaces.

TABLESPACE OBJECTSET objectSetName

Use TABLESPACE OBJECTSET objectSetName to specify the table spaces that are included in a BMC AMI Recovery Manager object set for which you want to make additional copies. The BMC AMI Recovery Manager object set is identified by objectSetName. Each original must be an existing registered local site primary copy or a registered recovery site primary copy. If the allocation of the primary copy fails, BMC AMI Copy will attempt to use the backup copy as input if it exists. objectSetName identifies the BMC AMI Recovery Manager object set that contains the table spaces.

Important

COPY IMAGECOPY TABLESPACE OBJECTSET is synonymous to COPY IMAGECOPY RMGROUP or COPY IMAGECOPY RMGROUPTS.

BMC AMI Copy does not allow wildcards to be specified with OBJECTSET and will issue messages regarding an invalid group name if wildcards are used.

BMC AMI Copy accesses the BMC Common Db2 repository and the Db2 catalog to retrieve the table spaces that are defined for the group.

For more information about BMC AMI Recovery Manager object sets, see the BMC AMI Recovery Manager for Db2 documentation .

Important

Only the table spaces are used from a BMC AMI Recovery Manager object set. Any index spaces that appear in the object set are ignored. You can add the INDEXES YES option to copy the indexes for the table spaces in the object set.

DSNUM cannot be specified with TABLESPACE OBJECTSET. Object set objects are copied using the DSNUM specified in the BMC AMI Recovery Manager object set. However, EXCLUDE is supported.



 

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