SQL Optimizer for DB2 LUW 4.3.1 - User Guide

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.

Create Benchmark Factory Import File

All the SQL statements can be saved in a text file from the Job Manager, the Scanned SQL Viewer, the SQL Repository, and the SQL Optimizer windows. These SQL statements can then be imported into Benchmark Factory program (version 4.6 or later).

To create the text file to import into Benchmark Factory

1. Right-click and select Create Benchmark Factory Import File.

2. Select the specific SQL statements that you want to save. Click OK.

3. Enter the filename and select the file location. Click Save.