Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.2 - User Guide

SQL Optimizer for IBM® DB2® LUW
UsageStatistics Getting Started Options SQL Scanner SQL Optimizer SQL Formatter SQL Inspector Database Explorer SQL Repository Index Impact Analyzer Index Usage Analyzer User-Defined Temp Table Editor Functions SQL Functions SQL Information and Functions Activity Log
Tutorials About us Copyright

Enter Authorization Key

SQL Optimizer requires an authorization key to use the program.

To enter another trial key or to enter the production key

  1. Select Help | Licensing.

  2. In the Licensing window, enter your key.

  3. For a production key, enter your site message.

  4. Click Apply.


  • The license key must be entered for each user logon on your computer.
  • A trial key is valid for thirty days.

Tip: Access the Licensing window any time to review current license information in the License Details pane.



Select Database Language

The first time the program is launched after you have installed it, the Language window appears. This window enables you to select the language character set that was used to enter and display the SQL and data in your database.

The Interface for the program is always in English.  

To select the language at the initial opening of SQL Optimizer

In the Character set field, select the language.

To select the language from the Options

  1. Click .

  2. Select the General tab.

  3. In the Character set field, select the language.


Related Topic

Status Bar—Main Window




Displays the selected schema and lists available schemas. Use the Schema list to select the schema that corresponds to the SQL statements that you are working with.


Read-only field, displaying the connected login for DB2 LUW.

Database Alias

Displays the DB2 LUW database alias for the current database.

Quest Assistant

Displays the Quest Assistant icon if Quest Assistant was minimized.

Connection Information

Displays the connection information icon if the user account does not have every privilege needed by every module.

Temp Table

Displays the temp table icon if a user-defined temp table has been created.

Special Registry Settings

Displays the special registry settings icon if you have made any changes to the DB2 LUW special registry settings using SQL Optimizer.

You may open the Quest Assistant, the Connection Information window, the User-Defined Temp Table window or the special Registry Settings window by clicking the corresponding icon on the Status Bar.



Availability of the toolbar buttons varies according to the active module. Buttons appear active when they are accessible and appear dimmed when they are not. By default all toolbar are shown.

To hide or show a toolbar

  1. Select Window | Customize Toolbars
  2. Select the toolbars you want to show.
  3. Clear the toolbars you want to hide.

To reset the toolbar to the default

Select Window | Customize Toolbars | Reset Default.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating