You can use your Data Design Projects to audit the changes that
have been made to your databases.
To extract your projects and to review the changes that have been
made, complete the following steps:
- Extract the label or tag for the specific change that needs to
be audited.
- Open the Deployment Script Editor to audit the change.
- Review the metadata and resources that are defined in the deployment
script to audit the following aspects of the change:
- Source models
- Base and target models
- All change commands
- A log of the command execution
- The scripts that are necessary to undo the change
- Compare your base and target models to determine the database objects
that were changed.
- Review the change commands to see the actual DDL, utilities, and
DB2 commands that are executed as part of the change.
- Review the connection information that shows the live database
from which the deployment script was developed.
Use the Last Action field to determine the last action
that was completed with this deployment script. You can find the history of
the actions that were completed in the XML for the deployment script on the XML
Source tab of the Deployment Script Editor. For example, if the deployment script has been deployed, you will
see the following: <history>
<event id="deployed" />
</history>
