Deploying undo commands

If a change to the target database fails or produces an undesirable result, you can roll back that change to recover the previous database. DB2® Change Management Expert provides the capability to undo your changes. The undo capability is enabled by default.
Start of changePrerequisite: Undo commands must exist in the deployment script before you attempt to deploy them. For information about creating undo commands see the Generating undo commands topic.End of change
Restriction: You can deploy undo commands to only one database at a time.
To undo changes that you have promoted to your target database, complete the following steps:
  1. On the Overview page in the Deployment Script Editor, click Deploy Undo Commands to start the Undo wizard. The Undo wizard contains the base model information, target model information, and default options that are necessary to restore the original database. In the Undo wizard, you can check your connection, enter your user ID and password, verify your change commands, and check that your deployment script contains the proper authorizations.

    You can also deploy your undo commands by clicking Deploy Undo Commands from the Undo Changes page of the Deployment Script Editor.

  2. Click Finish to undo the changes that you have made to the target database.
The target database returns to the state that it was in before you deployed your change. You can view the undo commands that were deployed in the Text Editor. You can also view the deployment results for each undo command in the Database Output view.

Start of changeThe Last Action field on the Overview page of the Deployment Script Editor will display Undo.End of change

Related concepts
Scenario: Undoing changes to the catalog
Related tasks
Creating a deployment script
Generating undo commands


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.