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 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 

Related topics

CHECKTSLEVEL

FULL

Making-SHRLEVEL-CHANGE-copies

Options-for-making-full-image-copies

RESETMOD

SHRLEVEL

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 the 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*