Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - Installation Guide

Start recording activities to the Activity Log

By default, the Activity Log is disabled.

during the SQL optimization process and query plan retrieval,

To start recording the activities

  1. Click image\B_Preferences.gif.

  2. Select the Activity Log tab.

Activity to be logged

Specify the activity to be logged by selecting the SQL optimization and/or the Query plan generation checkboxes. If no option is selected, the activity log is disabled.

Information to be logged

Specify the information to be collected by selecting the SQL text and/or Query plan checkboxes.

Note: Only activities executed in the SQL Optimizer window are logged.

The following information is recorded automatically for each activity logged:

PC user

PC user name.

Logon name

Database logon name.

Server

Adaptive Server name.

Activity Log directory

The Activity Log directory is used to store the log file created while recording the activities. Select the Directory Setup / Linkage tab to change the directory where the log is written. The default is the installed directory.

For example C:\Documents and Settings\User\Application Data\Quest Software\SQL Optimizer

Note: It is advisable not to change the Activity Log directory after selection, as log file is saved to this directory.

 

Related Topics

Related Documents