If you have archived a Data Design Project to a library
control system, you can import the Data Design project to review and
audit the changes that were made by deploying a change plan.
Before you begin
A connection to the database that you want to audit the changes
for must exist.
About this task
To audit your changes, you must use a workspace that does
not contain any Data Design change plan projects for the database.
Procedure
To import your projects and to review the changes that
were made, complete the following steps:
- Create a new workspace.
- From the main menu, click .
- Specify a name for the workspace and then click OK.
IBM® Data
Studio switches
to using this new workspace. Tip: You can switch back
to your previous workspace at any time by following the same steps
to create a workspace. However, instead of specifying a name for a
new workspace, use the Browse button to find
the name of your previous workspace.
- Import the Data Design Project that corresponds to the
specific change that you want to audit. The library control
system that you use determines how you can import your Data Design
Project. For example, if you use CVS, you can use the CVS
Repositories view to extract and import your project.
- In the Administration Explorer, expand the database that
was changed. Then, right-click the Change Plans folder
and click Refresh.
- If you are prompted to specify which project to use, select
the project that you just imported from the library control system.
- Click the Change Plans folder to
display the change plans in the Object List.
- Find the change plan that you want to audit and check the
following aspects of the change:
- The objects that were changed and their properties.
Right-click the change plan and click View. The changes in the change plan are displayed. To review the
properties of an object, right-click the object and click Properties.
- The DDL that was run to make the changes. Right-click
the change plan and click Review and Deploy to
display the DDL in the Review and Deploy dialog.
- The DDL that was created to undo the changes. Right-click
the change plan and click Review Undo Commands to
display the DDL in the Review and Deploy dialog.
- The change report that was generated when the change
plan was deployed. Right-click the change plan and click Review
change report to display the report.