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.
- 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
Related topics