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.

    Important

    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*