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.
Prerequisite: 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.

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:
- 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.
- 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.
The Last Action field on the Overview
page of the Deployment Script Editor will display Undo.