Skip to Content
Information

This site will undergo a brief period of maintenance on Thursday, 23 April at 2:30 AM Central/1:00 PM IST. During a 30 minute window, site availability may be intermittent.

Db2 system resource maintenance and recovery

Related topics
Before using BMC AMI Recovery Manager

For first time users of BMC AMI Recovery Manager

You can use BMC AMI Recovery Manager to automate the maintenance or recovery of Db2 system resources.

In general, Db2 does not need to be active to perform system resource maintenance and recovery tasks because these tasks do not require access to the Db2 catalog or to the repository. Exceptions are the recovery of the repository itself and the generation of disaster recovery JCL—both require Db2 to be active.

If Db2 is not active when you generate the maintenance or recovery JCL, BMC AMI Recovery Manager must get some of the bootstrap data set and archive log information from the control information records and some of it from you. This requirement is also true if the SCCAUTH module is not accessible for some reason (see APF authorization).

If you are authorized to access BMC AMI Recovery Manager, you can generate system resource maintenance and recovery JCL. However, you must also have authority to execute the Db2 utilities that are invoked by the JCL (see System resource authorization).

All of the system resource maintenance and recovery tasks are accessed through option 3. DB2 Subsystem Toolbox on the Main Menu and are described in the following table.

Task

Description

Backup and recovery of the Db2 catalog and directory (DSNDB01 and DSNDB06)

BMC AMI Recovery Managergenerates JCL to back up or recover the catalog and directory spaces in the correct sequence.

BMC AMI Recovery Manageruses DSNUTILB for these tasks. See Db2 catalog and directory.

Active and archive log recovery

BMC AMI Recovery Managergenerates JCL to recover the active and archive logs.

The procedures depend on whether single or dual logs are used and on whether the archive logs are cataloged. See Db2 active logs and Db2 archive logs.

BSDS maintenance and recovery

BMC AMI Recovery Managergenerates JCL to maintain or recover the BSDS.

The procedures depend on whether Db2 is active and the type of failure. Maintenance tasks generate Change Log Inventory jobs. See Db2 BSDS recovery and maintenance.

Work file database data set reallocation

BMC AMI Recovery Managerchanges work file allocations after a volume failure.

See Work file database.

View physical data set attributes

BMC AMI Recovery Manageruses the IDCAMS LISTCAT utility to obtain information about the physical attributes of both system and nonsystem data sets.

For more information, see Physical data set attributes.

Repository backup and recovery

BMC AMI Recovery Managergenerates JCL to back up or recover the BMC Common Db2 repository, BMC AMI Recovery Manager repository, the R+/CHANGE ACCUM repository (if installed), and the BMC AMI Log Master repository (if installed).

The BMC Common Db2 repository and the BMC AMI Recovery Manager repository store all information relating to application object sets and BMC AMI Recovery Manager options that you have created. See The Repository.

Disaster recovery planning assistance

BMC AMI Recovery Managerautomates procedures for disaster recovery preparation.

For more information about using BMC AMI Recovery Manager for disaster recovery planning, see Recovering from a Db2 system disaster.

Logging environment planning information

The BMC AMI Recovery Manager logging environment modeling tool allows you to examine and view different logging scenarios for a selected Db2 subsystem in order to optimize the amount of DASD space required by the active and archive logs.

For more information, see Modeling the Db2 logging environment.

 

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

BMC AMI Recovery Manager for Db2 13.1