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)
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.
View Activity Log Report
To print or view information stored in the Activity Log
The following information may be displayed according to the selected criteria.
User Information
|
Item |
Description |
|---|---|
|
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 |
|
The classified type of the original SQL statement. For example: Simple, Complex or Problematic. The SQL type is dependent on the Options settings. | |
|
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. |
|
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
-
Click
.
-
Select Activity Log tab.
-
Under the Housekeeping section, select Whole Log to remove all information
or
Specify a date range to remove logs between these dates.
-
Click Purge Now.