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

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

Monitoring Period

When you collect SQL currently executing my monitoring an application our a user during a specific period, the Monitoring Period page of the Add Inspector wizard displays:

Item Description
Start Date Specify the start date of the monitoring period.
End Date Specify the end date of the monitoring period.
Interval (minutes)

Specify how frequently the Inspector monitors SQL in milliseconds.

 

Related Topic

Add Inspector

Target Time

When you collect SQL currently executing by an application or a user at a specific moment, the Target Time page of the Add Inspector wizard displays:

Item Description

Capture immediately the currently executing SQL when the Inspect button is clicked

Click Inspect button to start capture immediately.

Capture SQL executing at:

Date

Specify the date you want to capture executing SQL.

Time (HH:MM):

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

Wait for some time and then capture what SQL are executing:

Wait time (HH:MM):

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

 

Related Topic

Add Inspector

Target Applications and Users

When you collect SQL currently executing, the Target Applications and Users page of the Add Inspector wizard displays:

Client Applications

Description

All Applications

Monitor all applications currently running.

Selected Application

Monitor a specific application.

Selected Agent ID

Displays Agent ID for the selected application.
Users Description

All Users

All available users.

Selected User

Use the arrows to select from Available Users.

 

Related Topic

Add Inspector

Related Documents