SQL Optimizer for DB2 LUW 4.4 - Installation Guide

Start Recording Activities

By default, the Activity Log is not created.

To start recording the activities during optimization and access plan retrieval

1. Click .

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.