Skip to Content

 

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Catalog Manager for Db2 13.1.

Simulating a drop

By simulating a drop, you can create DROP SQL statements and write them to the Drop Recovery Log without actually dropping the object.

The Drop Recovery Log is a Db2 table that is managed by Catalog Manager. It contains all of the information about dropped objects, their dependents, and the SQL to rebuild them that Catalog Manager needs to invoke the DSN1COPY utility to re-create the structures and authorizations.

To simulate a drop

  1. Set the Drop switch to N. For information, see Setting-Catalog-Manager-switches.When the Drop switch is set to N, Catalog Manager performs all of the actions for a drop except the actual execution. Then, Catalog Manager issues a message stating that the drop was not executed.
  2. Follow the steps in Dropping-an-object.

Related topic

Dropping-and-recovering-objects


 

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

BMC AMI Catalog Manager for Db2 12.1