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.

Default language.

Overview of automated drop recovery

Related topics

Product overview

Recovering dropped objects

Automated drop recovery step

Troubleshooting automated drop recovery

Adding an automated drop recovery step to a work ID

Example 1: Automated drop recovery of a single table

Example 2: Automated drop recovery of a partitioned table space
 

BMC AMI Log Master helps to automate the recovery of objects that have been dropped from the Db2 catalog. Using the information in the Db2 log, BMC AMI Log Master can create several types of output, depending on the type of recovery that you request. You also have the option of creating JCL statements that run the different forms of output in the correct order to accomplish the recovery. 

Success

Best practice
We strongly recommend that you use the BMC AMI Log Master online interface to define your automated drop recovery work ID. This work ID creates the forms of output that enable BMC AMI Log Master, working with a recover utility, to recover dropped objects.

BMC AMI Log Master works with the following recover utilities:

  • BMC AMI Recover to recover table spaces and tables
  • DSN1COPY to recover a single dropped table space
Warning

Important

The Db2 Recover utilities that BMC AMI Log Master works with do not support the recovery of “versioned” dropped objects that were altered but not reorganized. For information about limitations and special handling for recovery of versioned objects, see the documentation for your Recover utility.

 

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

BMC AMI Log Master for Db2 13.1