Copying the Db2 catalog and directory

Some content is unavailable due to permissions.

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

Some content is unavailable due to permissions.

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

Some content is unavailable due to permissions.

command that includes GROUP YES:

Related topics

Some content is unavailable due to permissions.

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
Some content is unavailable due to permissions.
issues the following message:
BMC180120W CATALOG/DIRECTORY INDEXES MUST USE 'INDEX YES' WITH COPY TABLESPACE
Some content is unavailable due to permissions.
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.

On this page