View Activity Log report
View Activity Log Report Criteria Window
You can save or print the information in the report.
To print or view information stored in the activity log
-
Select Report | Activity Log to open the Activity Log Report Criteria window.
-
Select the information to view.
-
Click OK to generate the report.
The following information may be displayed depending on the criteria you select.
User Information
| Item | Description |
|
PC User |
Windows user name used to logon to the PC. |
|
Logon Name |
Database logon name. |
|
Server Name |
Adaptive Server name. |
|
User |
Database user. |
|
Database |
Database name. |
Activity Information
| Item | Description | ||||||||||||||
|
Date |
Date of when the activity was executed. | ||||||||||||||
|
Activity |
Activity type SQL optimization (OP) Query plan generation (EP) | ||||||||||||||
|
Original SQL Type |
The SQL Classification of SQL the original SQL (Simple, Complex or Problematic). | ||||||||||||||
|
The information below is repeated for ALL RECORDS and FIRST RECORD. | |||||||||||||||
|
Status |
The current status of the activity.
| ||||||||||||||
|
Original SQL Time |
The run time of the original SQL statement. | ||||||||||||||
|
Best Alternative Time |
Best run time from the alternative SQL statements. | ||||||||||||||
|
Times of Improvement |
Calculates how much faster the alternative is in comparison to the original SQL statement. | ||||||||||||||
Note: The activity log information is retrieved from the Activity Log directory; therefore if any changes are made to this directory the information may not be retrieved.