Generating JCL to recover a Db2 archive log

This procedure generates JCL to recover a failed Db2 archive log.

You provide the required data and generate the recovery JCL. If the archive log is not cataloged, additional BSDS maintenance steps are necessary to generate recovery JCL.

Related topic

Db2-archive-logs

Before you begin

To perform this procedure, you need the following authorizations:

  • EXECUTE authority for BMC AMI Recovery Manager
  • Authority to use the Print Log Map utility
  • Data set authority to run the recovery JCL

To generate JCL to recover a Db2 archive log

  1. In the BMC AMI Recovery for Db2 Main Menu, select 3. DB2 Subsystem Toolbox.
  2. In the Db2 Subsystem Toolbox panel, select 3. Archive Logs.

  3. In the Archive Log Recovery panel, specify information as required and press Enter. For more information about the fields, see Archive-log-recovery-options.

    Warning

    If you select Delete for the disposition of a failed tape data set, it is uncataloged and you will not be able to rename the tape.

  4. 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.
  5. Save the JCL data set or submit the job as required.
  6. If the failed archive log data set is cataloged, no more steps are required. If the archive log is uncataloged, the JCL includes code to print the log map, and you must perform Step 7.
  7. Execute the JCL produced in Step 4 and review the output from the Print Log Map utility to determine what BSDS maintenance must be performed to complete the recovery. Follow the steps in the IBM Db2 Administration documentation using BMC AMI Recovery Manager to generate the maintenance jobs as described on BSDS-maintenance.

 

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