Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4 - Installation Guide

Directory Setup

The Directory Setup tab of the Options window allows you to define the directories for saving and opening files used in the different modules.

Directory for

Description

Default Directory

Open and Save dialog

Directory for opening and saving files with the Open or Save commands.

C:\Documents and Settings\username\Application Data\Quest Software\Quest SQL Optimizer for IBM DB2 LUW

Activity Log

Used to store the data files created while recording activities.

C:\Documents and Settings\username\Application Data\Quest Software\Quest SQL Optimizer for IBM DB2 LUW

SQL Scanner data

Used to store the data files created while scanning. Changes to this directory cannot be made while the SQL Scanner is active.

C:\Documents and Settings\username\Application Data\Quest Software\Quest SQL Optimizer for IBM DB2 LUW\DATA

SQL Repository data

Used to store the SQL statements saved in the SQL Repository.

C:\Documents and Settings\username\Application Data\Quest Software\Quest SQL Optimizer for IBM DB2 LUW

Index Usage Analyzer data

Used to store the information about each Index Usage Analysis.

C:\Documents and Settings\username\Application Data\Quest Software\Quest SQL Optimizer for IBM DB2 LUW

Index Impact Analyzer data

Used to store the information about each Index Impact Analysis.

C:\Documents and Settings\username\Application Data\Quest Software\Quest SQL Optimizer for IBM DB2 LUW

SQL Parameter History data

Used to store the information about variables that are used in the SQL statement.

C:\Documents and Settings\username\Application Data\Quest Software\Quest SQL Optimizer for IBM DB2 LUW\SQLPARAM

Caution: It is advisable not to change the data directory after selection, as files already created are kept in the original directory and are not moved to the new directory.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating