Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Recovery Manager for Db2 13.1.

Backing up and recovering the Db2 catalog and directory

This procedure generates backup or recovery JCL for the Db2 catalog and directory for the specified Db2 subsystem. You can exclude any spaces or indexes that you do not want to include in the generated JCL.

Note

When generating JCL to backup the Db2 catalog and directory with DSNUTILB, table spaces DSNDB01.SYSUTILX, DSNDB01.SYSLGRNX, and DSNDB06.SYSTSCPY cannot be in a LISTDEF and are generated in a separate step. The backup data set name for those objects will be the first node from the data set symbolic entered for the copy output data set options followed by database name, tablespace name, type with date then time.


Before you begin

To perform this procedure, you need the following items:

  • EXECUTE authority for BMC AMI Recovery Manager
  • Db2 SYSADM authority to execute the recovery JCL

  • Authority to execute backup JCL (for further information, see the IBM Db2 utility reference or the BMC AMI Copy for Db2 documentation)

  • The following information that is specific to catalog and directory backup or recovery:
    • Any spaces or indexes that you do not want to back up or recover
    • The following work unit information for index recovery:
  • The work unit (disk file) name
  • Primary and secondary allocations (if the sizing is not available)
  • Whether the allocations are for cylinders or tracks
  • Whether you want extracted index keys to be written to a work file before sorting

To generate JCL for Db2 catalog and directory recovery or backup

  1. In the BMC AMI Recovery for Db2 Main Menu, select System resources.
  2. In the System Resource Recovery and Maintenance panel, select Catalog and Directory to list all of the spaces and indexes in the catalog and directory.

  3. Generate JCL as follows:

    Note

    To exclude one or more objects from the backup or recovery JCL, type X in the Act column by each such object and then press Enter.

    • To generate recovery JCL, select Gen recover JCL in foreground and press Enter.
    • To generate backup JCL, select Gen backup JCL and press Enter.
  4. If you selected Gen backup JCL, continue with Step 6. If you selected Gen recover JCL in foreground, the Work File Options panel is displayed.
  5. Enter information as required and press Enter. For option descriptions, see Work-file-option-descriptions.
  6. When the JCL Specification panel appears, enter a fully qualified output data set name. Be aware of the following information:
    • The output data set is used for saving the JCL and must be cataloged. If not enclosed in quotes, the output data set will be prefixed by your TSO prefix.
    • The job statement must contain a symbolic variable (&#) for the job number. For more information, see Output-data-sets-job-cards-and-symbolic-variables.
  7. Save the JCL data set or submit the job as required.

Related topics

Db2-catalog-and-directory

Task-4-Creating-copies-of-the-Db2-catalog-and-directory



 

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