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

Activity Log

Quest SQL Optimizer for IBM® DB2® LUW maximizes SQL performance by automating the manual, time-intensive and uncertain process of ensuring that SQL statements are performing as fast as possible. SQL Optimizer analyzes, rewrites, and evaluates SQL statements within multiple database objects, files, or SQL statements captured by the DB2 Event Monitor. With SQL Optimizer, you can analyze and optimize all your problem SQL from multiple sources. SQL Optimizer also provides you a complete index optimization and plan change analysis solution, from index recommendations to simulated index impact analysis, through comparison of multiple SQL access plans.

SQL Optimizer provides you with the following main modules.

SQL Optimizer (including SQL Rewrite and Generate Indexes functions)

SQL Formatter

Database Explorer

SQL Scanner

SQL Inspector

SQL Repository

Index Impact Analyzer

Index Usage Analyzer

 

About Activity Log

The Activity Log is used to record activities during optimization and access plan generation. Information recorded can be used to review SQL quality and any improvement obtained from optimization.

 

Related Topics

View Activity Log Report

To print or view information stored in the Activity Log

  1. Select Report | Activity Log.

  2. Select the information to view.

The following information may be displayed according to the selected criteria.

User Information

Item

Description

PC User

The user name from the PC

Logon User

Database logon name

Database Alias

Database alias name

Schema

Schema name

Activity Information

Item

Description

Date

Date and time when the activity was executed.

Activity

The type of activity recorded:

OP – SQL Optimization

EP – Access Plan Generation

Original SQL Type

The classified type of the original SQL statement. For example: Simple, Complex or Problematic. The SQL type is dependent on the Options settings.

Status (All Records)

Current status of the activity relating to run time for all records.

Original SQL Elapsed Time

(All Records)

Run time for retrieving all the records of the original SQL statement.

Best Alternative Elapsed Time (All Records)

Run time for the SQL alternative that has the best alternative run time for all records.

Times of Improvement

(All Records)

The number of times faster the best alternative SQL is compared with the original SQL statement when comparing the run times for all records.

Status (First Record)

Current status of the activity relating to run time for the first record.

Original SQL Elapsed Time

(First Record)

Run time for retrieving the first record of the original SQL statement.

Best Alternative Elapsed Time

(First Record)

Run time for the first record from the SQL alternative that has the best alternative run time for the all records.

Times of Improvement

(First Record)

The number of times faster the best alternative SQL is compared with the original SQL statement when comparing the run times for the first record.

Note: The Activity Log information will be retrieved from the Activity Log directory. Therefore if any changes have been made to this directory, the information may not be retrieved.

 

Purge Activity Log Data

To purge the Activity Log data

  1. Click  image\B_Options.gif.

  2. Select Activity Log tab.

  3. Under the Housekeeping section, select Whole Log to remove all information

or

Specify a date range to remove logs between these dates.

  1. Click Purge Now.

 

Related Documents