Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.1 - 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 image\B_Options.gif.

  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.

Related Documents