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

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

Inspect

After adding or modifying an Inspector in the SQL Inspector window, SQL statements and statistics from the database are retrieved by executing the Inspect function. Only one Inspector can be started at a time.

To start the inspecting process

  1. Select an Inspector job.

  2. Click .

If the start time of the Inspector has not been reached, the SQL Inspector waits until it is time to begin. During and at the end of the inspecting, information is updated on the SQL Inspector window. Inspect terminates automatically once the end time is reached, except for ad-hoc inspecting. The ad-hoc inspecting process has no ending time so it must be terminated manually.

To abort the inspecting

Click .

Note: If you have already executed the Inspect function for an Inspector, re-executing the Inspect function will erase all existing information.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating