Skip to Content

Modifying the Db2 catalog and directory

You can use the MODIFY command to update recovery resources for the Db2 catalog and directory using the keyword DB2CATALOG.

Only the following syntax is allowed:

MODIFY RECOVERY TABLESPACE DB2CATALOG INDEXES YES

Related topic

Using-the-MODIFY-command

You must use INDEXES YES if you want to modify indexes, and the indexes must have been defined with the COPY YES attribute. MODIFY RECOVERY INDEXSPACE or MODIFY RECOVERY INDEX is not allowed. When you use the DB2CATALOG wildcard, MODIFY excludes DSNDB07 and other work file databases.

The following restrictions apply when the keyword is not used:

  • DSNDB06.SYSCOPY, DSNDB01.SYSUTILX, DSNDB01.DBD01, and DSDNB01.SYSDBDXA is not allowed. These table spaces have no SYSCOPY information. Using the MODIFY command with these table spaces causes MODIFY to issue an informational message but does no processing. This functions in the same manner as the Db2 MODIFY RECOVERY utility.
  • Wildcards (* or %) are ignored for catalog and directory table spaces.
  • Work table spaces cannot be modified.

 

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

BMC AMI Copy for Db2 13.1