Importing Data Design Projects from a library control system to audit changes

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:

  1. Create a new workspace.
    1. From the main menu, click File > Switch Workspace > Other.
    2. 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.
  2. 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.
  3. In the Administration Explorer, expand the database that was changed. Then, right-click the Change Plans folder and click Refresh.
  4. If you are prompted to specify which project to use, select the project that you just imported from the library control system.
  5. Click the Change Plans folder to display the change plans in the Object List.
  6. Find the change plan that you want to audit and check the following aspects of the change:
    1. 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.
    2. 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.
    3. 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.
    4. 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.

Feedback