Scenario: Undoing changes to the catalog

Show Me
You deployed a deployment script against the test database. In the deployment script, TEST_BASE is the base model and TEST_TARGET is the target model. The Generate Change Command wizard generates both change commands and undo commands provided that you have enabled these two options. You can use these undo commands if you decide to undo the changes to the test database.

Undoing a change reverts the database catalog back to your base model. The base model, TEST_BASE, can now be thought of as the target model because it acts as a representation of the catalog after the undo process is completed. The target model, TEST_TARGET, can be thought of as the base model because it acts as a representation of the catalog before the undo process begins.

  1. In the Data Project Explorer view, select your deployment script. The Deployment Script Editor opens.
  2. Click the Undo Changes tab of the Deployment Script Editor. The Undo Changes page is displayed. The Define Undo Commands section lists the change commands that DB2® Change Management Expert uses to undo your changes. You can view these undo commands in a text editor by selecting the command from the list and clicking Edit.
  3. Click Deploy Undo Commands to start the Undo wizard, which will deploy the undo commands and roll back your changes from the database catalog.

    Optional: You can also click Deploy Undo Commands directly from the Overview tab of the Deployment Script Editor if you do not need to review the contents of the commands. The Undo wizard starts.

  4. Complete the steps in the Undo wizard and click Finish. DB2 Change Management Expert deploys the undo commands and reverses the changes that you previously deployed to the catalog. The database catalog is restored to the state it was in before you implemented the change.
Related tasks
Deploying undo commands


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.