Skip to Content

Db2 catalog and directory

You can generate backup and recovery JCL for any of the catalog and directory table spaces and indexes in DSNDB01 and DSNDB06 in the Db2 subsystem.

The contents of the Db2 catalog and directory vary by version and release of Db2. If Db2 is active, BMC AMI Recovery Manager automatically obtains the version of Db2 that is installed. If Db2 is not active, BMC AMI Recovery Manager obtains the version from the BMC AMI Recovery Manager option set (ARM$OPTS). You should verify that the options set contains the correct version of Db2.

Related topics

Managing-DB2-Subsystem-Toolbox

Db2-system-resource-maintenance-and-recovery

When you use the catalog and directory recovery feature, BMC AMI Recovery Manager handles backup and recovery options as follows:

  • For backups, the utility options in effect for the current subsystem are used; no object set level options are available. Additionally, the following restrictions apply:
    • You cannot use BMC AMI Recover as the backup utility.
    • You cannot use the SNAPSHOT UPGRADE FEATURE (SUF) for SYSCOPY, SYSUTILX, or DSNDB01 spaces.

    • You cannot use the COPY IMAGECOPY command for SYSCOPY, SYSUTILX, or DSNDB01 spaces.

      If the subsystem options in effect violate any of the listed restrictions, BMC AMI Recovery Manager uses DSNUTILB (IBM Db2 COPY(DSNUTILB)) as the backup utility.

  • For recoveries, you cannot change either the recovery options or save the object set to the repository. BMC AMI Recovery Manager uses only the DSNUTILB utility (IBM Db2 RECOVER (DSNUTILB)); you cannot use BMC AMI Recover.
Warning

Important

If you are recovering a volume object set that contains catalog and directory objects, you should recover the catalog and directory objects before you recover any applications on the volume.

Use the procedure Backing-up-and-recovering-the-Db2-catalog-and-directory to generate the JCL that is required for catalog and directory backup or recovery.

 

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

BMC AMI Recovery Manager for Db2 13.1