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 the Db2 catalog and directory


BMC AMI Copy

 provides support for copying Db2 catalog and directory table spaces located in databases DSNDB01 and DSNDB06.

If you dynamically allocate the output copy data sets and use the DB2CATALOG wildcard (see Using-the-DB2CATALOG-wildcard), BMC AMI Copy identifies all of the table spaces and copies them in the correct sequence.

To copy the catalog and directory with BMC AMI Copy version 10.1 and later, you do not need to exclude the following catalog and directory table spaces from an BMC AMI Copy command that includes GROUP YES:

  • DSNDB06.SYSCOPY
  • DSNDB01.SYSUTILX
  • DSNDB01.DBD01
  • DSDNB01.SYSDBDXA (for Db2 Version 11 and later)

BMC AMI Copy treats the catalog and directory table spaces in the same way as table spaces containing application data. Note the following considerations:

  • You must specify DSNUM ALL or DSNUM PART.
  • You must specify IXDSNUM ALL with DB2CATALOG for indexes or an error might occur.

    Important

    Only COPY YES indexes will be copied. To copy COPY YES indexes, specify COPY TABLESPACE DB2CATALOG INDEXES YES. Specifying COPY INDEXSPACE DB2CATALOG results in a failure, and BMC AMI Copy issues the following message:

    BMC180120W CATALOG/DIRECTORY INDEXES MUST USE 'INDEX YES' WITH COPY TABLESPACE
  • BMC AMI Copy no longer has any restrictions based on the GROUP option.
  • The following table spaces are isolated from a group and registered at different points:
    • DSNDB01.SYSLGRNX
    • DSNDB01.SYSUTILX
    • DSNDB06.SYSCOPY
    • DSDNB01.SYSDBDXA
  • If MAXTASKS is greater than 1, the following table spaces are always copied in task 1:
    • DSNDB01.DBD01
    • DSNDB01.SCT02
    • DSNDB01.SPT01
    • DSNDB01.SYSLGRNX
    • DSNDB01.SYSUTILX
    • DSNDB06.SYSCOPY
    • DSDNB01.SYSDBDXA

Important

Before copying Db2 catalog or directory table spaces, read the table space status information from Initial-status-considerations-for-copy-jobs through Initial status and the SHRLEVEL option.


 

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