Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.3.1 - User Guide

SQL Optimizer for IBM® DB2® LUW
About SQL Optimizer for IBM DB2 LUW 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

SQL Inspector Overview

The SQL Inspector identifies SQL statements with performance problems by extracting SQL statements and SQL performance statistics from the database. With the Add Inspector window, you can create an Inspector, select which approach to use, and specify your retrieval criteria and timeframe for capturing the SQL statements.


Related Topics


SQL Inspector Functions

Data Directory Setting

The SQL Inspector data directory is where the data files are created while executing the Inspect function. The data directory path is set in the Options window.

  1. Click .

  2. Select the Directory Setup tab.

The default setting for this directory is:

C:\Users\User\Application Data\Quest Software\Quest SQL Optimizer for DB2 LUW\DATA

Changes to this directory cannot be made while the SQL Inspector is active.

Note: It is advisable not to change the data directory after you have used this function, as files created during inspecting are kept in this directory.


Related Topic

Open SQL Inspector

To open the SQL Inspector window

Click .


Related Topics

SQL Inspector Window

The SQL Inspector window consists of the Inspector List pane, Statistics pane, SQL Text pane, and status bar.

Inspector List pane

The Inspector List pane stores information on each Inspector. Information includes:

Item Description

Inspector Name

User-defined unique Inspector name.


Current status on the Inspector. This column will remain blank until inspecting starts.

No. of SQL

Total number of SQL statements retrieved from the monitoring tables.

Start At

Date and time of when the inspecting process starts.

End At

Date and time of when the inspecting process ends.

Last Modified

Date and time of when the Inspector was last modified.


Description of the Inspector defined by the user.

Statistics pane

Displays statistics for each SQL statement retrieved from the database:

SQL Text pane

Displays the SQL text for the statistic that is selected in the Statistics pane.

Status Bar Information

The status bar consists of the following information:

Item Description

Data Directory

Directory path shows where the data files produced during inspecting are saved. You can define the path of your data directory in the Preferences window. While inspecting, a progress bar will be shown to indicate the inspecting progress.

Total Inspectors

Total number of Inspectors.


Total number of Inspectors already executed.


Total number of Inspectors that have not been executed.


Related Topics


SQL Inspector Functions

Open SQL Inspector

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating