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

Add Inspector

To add an Inspector

Click .

 

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

Related Documents