Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.1 - User Guide

SQL Optimizer for IBM® DB2® LUW
UsageStatistics Getting Started Options SQL Scanner SQL Optimizer SQL Formatter SQL Inspector Database Explorer SQL Repository Index Impact Analyzer Index Usage Analyzer User-Defined Temp Table Editor Functions SQL Functions SQL Information and Functions Activity Log
Tutorials About us Copyright

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 image\B_ScannedSQLViewer.gif

    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.

Button

Menu Item

Description

image\B_FirstJob.gif

Job | First Job

Display the first Job.

image\B_PreviousJob.gif

Job | Previous Job

Display the previous Job.

image\B_NextJob.gif

Job | Next Job

Display the next Job.

image\B_LastJob.gif

Job | Last Job

Display the last Job.

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.

 

Related Documents