Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 5.0 - 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

Abort Inspect

After the Inspect function has been executed from the SQL Inspector window, it can be aborted at any time.

To abort the inspecting

Click .

It may take several seconds for all the events to close down.

 

Related Topics

Inspect

Scan Inspector

The SQL statements collected by the Inspector can be scanned in the SQL Scanner to classify the SQL statements to help identify which SQL statements are likely to be causing performance problems.

To scan an Inspector from the SQL Inspector window:

  1. Select an Inspector job.

  2. Right-click and select Scan.

The selected Inspector is copied to the SQL Scanner window for scanning. If the SQL Scanner window is not opened then you will need to first select or create a job group from the Group Manager window. Once added, the scanning starts automatically.

 

Related Topics

Delete Inspector

To delete an Inspector

  1. Click the Inspector row.

  2. Press Delete.

Note: Only one Inspector can be deleted at a time.

 

Related Topics

SQL Inspector Overview

SQL Inspector Window

Find Inspector

To search for a specified text in all Inspectors

  1. Select Inspector | Find Inspectors.

  2. Enter the search text string

  3. Click Find.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating