Using a library control system to undo multiple changes

You can use your library control system to undo multiple changes that you have made to your database.

Before you begin

A connection to the database that you want to undo changes for must exist.

About this task

To undo changes, you must use a workspace that does not contain any Data Design change plan projects for the database.

Procedure

To undo multiple changes, complete the following steps:

  1. Create a new workspace.
    1. From the main menu, click File > Switch Workspace > Other.
    2. Specify a name for the workspace and then click OK.
    IBM® Data Studio switches to using this new workspace.
    Tip: You can switch back to your previous workspace at any time by following the same steps to create a workspace. However, instead of specifying a name for a new workspace, use the Browse button to find the name of your previous workspace.
  2. Import the Data Design Project that corresponds to your latest change. The library control system that you use determines how you can import your Data Design Project. For example, if you use CVS, you can use the CVS Repositories view to extract and import your project.
  3. In the Administration Explorer, expand the database that was changed. Then, right-click the Change Plans folder and click Refresh.
  4. If you are prompted to specify which project to use, select the project that you just imported from the library control system.
  5. Click the Change Plans folder to display the change plans in the Object List.
  6. Undo the changes for the change plan.
    1. Right-click the change plan that has the changes that you want to undo and then click Review Undo Commands. The DDL to undo the changes is displayed in the Review and Deploy dialog.
    2. Click Run and then click Finish.
  7. Repeat steps 2 through 5 until you have undone all of the changes that you want to undo. You must undo your changes in the reverse of the order that you made the changes, and you must not skip any changes.

What to do next

After you undo your changes, your database catalog is returned to an earlier state.
Important: If data preservation was enabled, the data files were created when the change was deployed. These data files will be imported after the undo DDL is imported. If updates were made to the database after the change that you are trying to undo was made, be careful not to overwrite important changes. Depending on the situation, you might need to take additional action to ensure that the data that you are importing is current.

Feedback