Skip to Content

Using the DB2CATALOG wildcard

You can use the special wildcard DB2CATALOG in a COPY statement to make full or incremental image copies of all Db2 catalog and directory spaces and their indexes.

However, when you use this wildcard in a COPY IMAGECOPY statement, special case catalog and directory spaces are excluded (see Copying-special-case-catalog-and-directory-table-spaces). You can use DB2CATALOG in a RECALL statement to reinstate hidden incremental copies of the Db2 catalog and directory spaces. Use DB2CATALOG with the QUIESCE command to quiesce all spaces.

Related topics

Copying-the-Db2-catalog-and-directory

Using-wildcard-characters-in-the-object-name-specification

When you use this wildcard with the COPY command, the special case spaces are included and are copied in the correct order for recovery. When you use the wildcard with the COPY IMAGECOPY command, BMC AMI Copy selects catalog and directory spaces in the reverse order and excludes special case spaces.

The following example copies the Db2 catalog and directory spaces.

COPY TABLESPACE DB2CATALOG ....other options

The following example copies the Db2 catalog and directory spaces and the indexes defined with COPY YES.

COPY TABLESPACE DB2CATALOG .... INDEXES YES

For a more detailed example of the JCL and SYSPRINT output, see Example-6-Copying-the-Db2-catalog-and-directory.

 

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

BMC AMI Copy for Db2 13.1