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 ALTER and BMC AMI Change Manager for Db2 13.1.

Restoring data structures with current data

Use the following procedure to restore a previous version of your data structures from a catalog baseline and use the data that is currently stored in Db2.

Related topics

Executing-an-alter-type-worklist

Accomplishing-your-maintenance-goals

This process is sometimes referred to as falling back to a previous version. To automate this process with a script, see Recovering-data-structures-with-current-data.

Before you begin

Ensure that a catalog baseline exists. For information about catalog baselines, see Taking-a-snapshot-of-a-database-environment.

To restore data structures

  1. Compare the Db2 catalog to the baseline. See Comparing-a-Db2-catalog-to-a-baseline.
  2. Import the CDL from the comparison in Step 1 to an alter-type work ID.
    1. Create an alter-type work ID. See Creating-an-alter-type-work-ID for more information.
    2. Import the CDL to the work ID that you created in Step 2.a. For more information, see Importing-a-CDL-DDL-or-DML-file-to-Change-Manager.

  3. Analyze the alter-type work ID and generate a worklist. For more information, see Analyzing-an-alter-type-work-ID-and-generating-a-worklist-in-Change-Manager.

    Note

    On the Analysis Alter Worklist Interface panel, select Generate a worklist which will convert and reload current data. If the scope rules for a baseline profile have changed since the last baseline was built, Analysis issues a warning message in the diagnostic output file.

  4. Execute the worklist.

 

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