Running Impact Analysis Reports

How to:

An Impact Analysis report enables you to determine the impact of changing a synonym, synonym column, or procedure. The report shows you how and where the object is used. For example, running the report on a procedure tells you from which applications and procedures the original procedure is run. Running the report on a synonym tells you which tables or other data sources the synonym describes, and in which procedures it is referenced. This enables you to determine how changing the synonym, column, or procedure could affect the rest of your application.

You can run Impact Analysis reports from the Web Console and from the Data Management Console. When run from the Data Management Console, reports also provide drill-down links so that you can, for example, run an Impact Analysis report on a synonym, see a procedure listed in the report, and click the procedure to edit it.

In addition to the reports you can run for an individual procedure, synonym, or column, you can select the following standard Impact Analysis reports for an Application folder in the Web Console or the Data Management Console:

Note: Enterprise reports appear only if you have subservers.


Top of page

x
Procedure: How to Run an Impact Analysis Report for an Application

You can run an Impact Analysis Report from the Web Console or the DMC.

  1. From the Web Console menu bar, click Applications, or from the Data Management Console, expand the Server node folder.

    On the Web Console, the Applications page opens.

  2. Right-click an application folder, select Impact Analysis, and then either:
    • Synonyms by Procedure
    • Procedures by Synonym
    • Columns by Procedure
    • Procedures by Column
    • Flow Report

The Impact Analysis report opens in the right pane.


Top of page

x
Procedure: How to Run an Impact Analysis Report for a Procedure

You can run an Impact Analysis Report from the Web Console or the DMC.

  1. From the Web Console menu bar, click Applications, or from the Data Management Console, expand the Server node folder.

    On the Web Console, the Applications page opens.

  2. Expand an application folder.
  3. Right-click a procedure, select Impact Analysis.

The Impact Analysis report opens in the right pane.


iWay Software