Extracting Data Design Projects to audit changes

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:
  1. Extract the label or tag for the specific change that needs to be audited.
  2. Open the Deployment Script Editor to audit the change.
  3. 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
  4. Compare your base and target models to determine the database objects that were changed.
  5. Review the change commands to see the actual DDL, utilities, and DB2 commands that are executed as part of the change.
  6. Review the connection information that shows the live database from which the deployment script was developed.
  7. Start of changeUse 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>
    End of change


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.