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.

    Important

    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*