Chat now with support
Chat with Support

We are currently experiencing issues on our phone support and are working diligently to restore services. For support, please sign in and create a case or email supportadmin@quest.com for assistance

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

General Information

The General Information page of the Add Inspector wizard consists of the following settings:

Item Description

Inspecting Approach

Select from the following:

  • Executing SQL sent by an application or user within a set time period
  • Executing SQL sent by an application or user
  • SQL executed within a set time period
  • SQL executed at a set time

Inspector name

Enter a name for the Inspector.

Last Modified

The date and time the Inspector was last modified.

Description

Enter a description for the Inspector.

 

Related Topic

Add Inspector

Collection Period

When you collect SQL executed within a specific period, the Collection Period page of the Add Inspector wizard displays:

Item Description

Start date

Specify the collection start date.

End date

Specify the collection end date.

Interval (minutes)

Specify the frequency of the collection in minutes.

 

Related Topic

Add Inspector

Collection Time

When you collect SQL executed before a specific time, the Collection Time page of the Add Inspector wizard displays:

Item Description

Start collecting SQL only when the Inspect button is clicked

Start collection when you click the Inspect button.

Start collecting SQL at a specific time:

Date

Specify the date you want to collect SQL.

Time (HH:MM):

Specify the time you want to collect SQL in hours and minutes.

Start collecting SQL after a wait period:

Wait time (HH:MM):

Specify the time you want to wait before you collect SQL in hours and minutes.

 

Related Topic

Add Inspector

SQL Filter

When you collect SQL executing before a specific time, the SQL Filter page of the Add Inspector wizard displays:

Item Description

Select SQL Type

Select the appropriate checkbox for the SQL type you want to filter.

All SQL

Select to filter all SQL.

 

Related Topic

Add Inspector

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating