Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Automated drop recovery

The BMC Recovery Management for Db2 solution assists in the recovery of dropped objects.

This type of recovery is generally needed for an error caused by an application program or by user errors.

Drop recovery is handled by the Log Master and

Some content is unavailable due to permissions.

components of the BMC Recovery Management for Db2 solution.

Related topics

Multi-component-features

Performing-local-recovery

To perform an automated drop recovery, you first specify information about the Db2 objects that were dropped from the catalog, as follows:

  • Type of objects to recover (table, table space, or database)
  • Name of each object to recover
  • Time frame when the objects were dropped from the catalog

Based on your input, Log Master scans the log for information relating to the dropped Db2 objects, then generates several forms of output that enable Log Master (working with

Some content is unavailable due to permissions.

) to recover the dropped objects. The output can include

  • DDL statements to create the dropped objects in the Db2 catalog

  • Some content is unavailable due to permissions.

    syntax to recover a table or table space
  • SQL statements for populating a recovered table with data
  • Db2 commands to rebind any application plans that were invalidated when the objects were dropped

  • A Drop Recovery report that provides summary information about the Db2 objects that you want to recover

    The information includes the specific image copy that should be used for the recovery and OBID translation information.

  • JCL statements to execute the different types of output in the right order to accomplish the recovery

    You can direct Log Master to execute all or part of the generated JCL.

We strongly recommend that you use the Log Master online interface to define your automated drop recovery. For step-by-step instructions on recovering dropped objects, see BMC AMI Log Master for Db2 documentation

For information about using batch syntax, look for information on the DROPRECOVERY statement in the BMC AMI Log Master for Db2 documentation and in the BMC AMI Recover for Db2 documentation

 

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