Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.3.1 - Release Notes

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.

Status

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

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.

Completed

Total number of Inspectors already executed.

Remaining

Total number of Inspectors that have not been executed.

 

Related Topics

Inspect

SQL Inspector Functions

Open SQL Inspector

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating