SQL Optimizer for DB2 LUW 4.4 - User Guide

Open Scanned SQL Viewer

Once the Job has been scanned and the SQL statements found, view the SQL statements through the Scanned SQL Viewer.

To open the Scanned SQL Viewer window

• Click

  or

• Double-click the Job

View a Particular Type of SQL Statement

When the Scanned SQL Viewer window is first opened all SQL statements in the selected Job are shown. Customization of the view allows the displaying of: All, Simple, Problematic, Complex, and/or Invalid SQL statements. In addition, you can view the Checked and/or Unchecked SQL statements. The title bar of the Scanned SQL Viewer window displays the chosen criteria. One or more types of SQL statements can be viewed by selecting or de-selecting the menu items. The Job list contains all the Jobs using the chosen view criteria:

To display all SQL statements

Select View | All SQL.

To display the Simple SQL statements

Select View | Simple SQL.

To display the Problematic SQL statements

Select View | Problematic SQL.

To display the Complex SQL statements

Select View | Complex SQL.

To display the invalid SQL statements

Select View | Invalid SQL.

To display SQL statements with different bound and new access plan that satisfy the selected SQL classification type

Select View | Different Bound and New Access Plan.

To display SQL statements with no bound access plan that satisfy the selected SQL classification type

Select View | No Bound Access Plan.

To displays all Checked SQL statements

Select View | Checked SQL.

To displays all Unchecked SQL statements

Select View | Unchecked SQL.

Job Navigation

There are several ways to navigate through the Jobs in the Scanned SQL Viewer window:

• Double-click the Job to be viewed in the Job Manager window.

• Select the Job from the Job list.

• Use the navigation buttons on the toolbar or corresponding menu items.

Generate Report for Scanned SQL Statements

To generate a report for scanned SQL statements

1. With the Scanned SQL Viewer window open select Report | Scanned SQL to open the Scanned SQL Report Criteria window.

2. Select the report criteria.

3. The information in the report can be saved or printed.

Note: A few minutes may be needed to generate a long report.