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

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

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating