Db2 system resource maintenance and recovery
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 the System resources option 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 Manager generates JCL to back up or recover the catalog and directory spaces in the correct sequence. BMC AMI Recovery Manager uses DSNUTILB for these tasks. See Db2-catalog-and-directory. |
Active and archive log recovery | BMC AMI Recovery Manager generates 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 Manager generates 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 Manager changes work file allocations after a volume failure. See Work-file-database. |
View physical data set attributes | BMC AMI Recovery Manager uses 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 Manager generates 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 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 Manager automates 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. |