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:
- Create a new workspace.
- From the main menu, click .
- 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.
- 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.
- In the Administration Explorer, expand the database that
was changed. Then, right-click the Change Plans folder
and click Refresh.
- If you are prompted to specify which project to use, select
the project that you just imported from the library control system.
- Click the Change Plans folder to
display the change plans in the Object List.
- Undo the changes for the change plan.
- 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.
- Click Run and then click Finish.
- 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.