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.

Recovering data structures with old data

The CM/PILOT RCV_STRUC_OLD_DATA script contains the steps to recover data structures from a full-recovery baseline and load the data that was unloaded when the baseline was created.

Related topics

Executing-an-alter-type-worklist

Accomplishing-your-maintenance-goals

The old data is loaded into the recovered data structures. All of the data that was saved in the original full-recovery baseline and the changed data structures are loaded into the tables. The referential integrity of the application’s data for the given point in time is maintained.

To accomplish this task, the product compares the Db2 catalog to a full-recovery baseline and generates a CDL file if differences exist between the data structures. If the BMC AMI Change Manager for Db2 Compare component finds no differences, CM/PILOT worklist processing stops, and an Analysis worklist is not created. If differences exist, a CDL file is created and imported, and an Analysis worklist is created to apply the changes.

In this procedure, you create and execute a task ID.

Before you begin

Using Change Manager, create a catalog baseline profile and a full-recovery baseline. For information, see Creating-a-catalog-baseline-profile and Creating-a-full-recovery-baseline.

To create a task ID

  1. On the BMC AMI Change Manager for Db2 Main Menu, select CM/PILOT, and press Enter.
  2. On the CM/PILOT Main Menu, select TASKIDs and press Enter.
  3. On the TASKID Action Menu , type the name of a new TASKID and select Create a TASKID. Then, press Enter.
  4. On the Script Selection List, select Recover data structures with old data and press Enter.
  5. On the Create TASKID panel, specify the information for a task ID.
    1. CM/PILOT uses the name of the task ID as the name for a new alter-type work ID. You can type a different name for WORKID or type the name of a work ID name template.
    2. (Optional) Type the name of a CM/PILOT Application. An Application groups a set of Change Manager profiles. For more information about Applications, see Using-scripting-tools-to-automate-change-management.
    3. (Optional) Specify a Comment to describe the task ID.
    4. Press Enter. Then, press END.The task ID is created.

To execute the task ID

  1. On the TASKID Action Menu panel, select Execute a TASKID and press Enter.
  2. On the TASKID Interface panel, specify the data set names to be used by CM/PILOT.
    1. Type the data set name for the CM/PILOT Worklist.
    2. Type the data set name for the CM/PILOT JCL.
    3. Type the data set name for Diagnostics or type SYSOUT.
  3. Select the method of executing the CM/PILOT worklist.For more information about executing a CM/PILOT worklist, see Processing-CM-PILOT-worklists.
  4. (Optional) Override the options that are set in Change Manager.

    1. Type S to select Override 

      Change Manager

       options and then press Enter.

    2. On the Override Change Manager Options panel, select Override 

      Change Manager

       Options.

    3. Type S to select the Change Manager Analysis and Execution options that you want to override, and press Enter.For more information about the options, see Using-options-to-control-your-environment.

      Warning

      BMC does not recommend that you select the Autosubmit override option. This powerful option automatically submits the JCL, which is created from the CM/PILOT generated worklist, to Execution. When you use the Autosubmit override option, use caution because any error in your specifications might cause significant damage to your schemas and a loss of data.

    4. Press END until the TASKID Interface panel is displayed.
  5. On the TASKID Interface panel, create a CM/PILOT worklist.
    1. Type S to select Create Worklist. Then, press Enter.
    2. (Optional) On the Step Settings panel, to modify the Execution step, type S to select Step 3 Execution step and press Enter.
    3. Press Enter until the Taskid Compare CDL Options panel is displayed.
  6. On the Taskid Compare CDL Options panel, specify the object types and attributes for the comparison.
    1. Type Y or N for each object type that you want to include in or exclude from the comparison.
    2. Type S to display a list of the object attributes to include in or exclude from the comparison.
    3. On the Compare Object Attributes panel, if you selected to display a list of the object attributes, specify the object attributes.
      1. To include an object attribute in the comparison, type Y adjacent to the attribute.
      2. If you specified to include the partition attributes, you can exclude one or more of the partition attributes. Type N adjacent to the attributes that you want to exclude.
      3. Press Enter to return to the Taskid Compare CDL Options panel.
    4. Press Enter.
  7. On the TASKID Migrate Profiles panel, specify the migrate profiles.
    1. (Optional) Specify the name of an outbound migrate profile. The outbound migrate profile can contain change rules and locations. Change Manager applies the rules after it performs the comparison (when it generates the CDL).
    2. (Optional) Specify the name of a second outbound migrate profile. The outbound migrate profile must contain change rules to resolve the names of the objects and creators. Change Manager applies the change rules to the objects before the comparison.
    3. (Optional) Specify the name of an inbound migrate profile. The inbound migrate profile can contain change rules. It can be used when the CDL that is generated from the comparison is imported.
    4. Press Enter.
    5. On the TASKID Existing Baselines panel, specify the name of the full-recovery baseline and press Enter.
    6. On the Change Manager Datasets panel, specify the CDL file and the data set names to be used by the Import, Analysis, and Execution components of Change Manager. Then, press Enter until the TASKID Interface panel is displayed.

  8. On the TASKID Interface panel, select your options for processing the CM/PILOT worklist.

    1. To edit the CM/PILOT worklist, type S to select Edit Worklist.
    2. To create the JCL to run the worklist, type S to select Create JCL.
    3. To review or modify the JCL, type S to select Edit JCL.
    4. To submit the JCL to run the CM/PILOT worklist, type S to select Submit JCL.
    5. Press Enter.

    CM/PILOT creates an Analysis worklist and the Execution JCL that is required to run the worklist.

  9. To recover the data structures, execute the Analysis worklist.

    Note

    The JCL that you use to execute the Analysis worklist is contained in the data set that you specified for JCL Dataset Name in the Change Manager Datasets panel.

 

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