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.
Start Recording Activities
By default, the Activity Log is not created.
To start recording the activities during optimization and access plan retrieval
-
Click
-
Select the Activity Log tab.
-
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.
-
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
-
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.