Tchater maintenant avec le support
Tchattez avec un ingénieur du 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

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.

 

Start Recording Activities

By default, the Activity Log is not created.

To start recording the activities during optimization and access plan retrieval

  1. Click image\B_Options.gif.

  2. Select the Activity Log tab.

  3. In Activity to be logged section, select SQL optimization and/or Access plan generation.

    Note: If no option is selected, the Activity Log is not created.

  4. In the Information to be logged section, select SQL text or/and Access plan.

    The following information will be recorded automatically for each activity logged:

    Item

    Description

    PC User

    The user name from the PC

    Logon User

    Database logon name

    Database Alias

    Database alias name

    Schema

    Schema name

  5. Select the Directory Setup tab to change the directory where the Activity Log is stored. The default is the installation directory.

    C:\Documents and Settings\username\Application Data\Quest Software\Quest SQL Optimizer for IBM® DB2® LUW.

 

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation