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 old data

Use the following procedure to restore a previous version of your data structures from a full-recovery baseline and load the data that was unloaded when the full-recovery baseline was created.

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-old-data.

Before you begin

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

To restore data structures

  1. Compare the Db2 catalog to the full-recovery 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. For more information, see Creating-an-alter-type-work-ID.
    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

    From the Analysis Alter Worklist Interface panel, select Generate a worklist which will reload data from a previous full-recovery baseline. 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.

    All of the data that is saved in the baseline is recovered.

  4. Execute the worklist.

 

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