Enter Authorization Key
SQL Optimizer requires an authorization key to use the program.
To enter another trial key or to enter the production key
-
Select Help | Licensing.
-
In the Licensing window, enter your key.
-
For a production key, enter your site message.
-
Click Apply.
Notes:
- 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
-
Click
.
-
Select the General tab.
-
In the Character set field, select the language.
Status Bar—Main Window
|
Item |
Description |
|---|---|
|
Schema |
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. |
|
Login |
Read-only field, displaying the connected login for DB2 LUW. |
|
Database Alias |
Displays the DB2 LUW database alias for the current database. |
|
|
Displays the Quest Assistant icon if Quest Assistant was minimized. |
|
|
Displays the connection information icon if the user account does not have every privilege needed by every module. |
|
|
Displays the temp table icon if a user-defined temp table has been created. |
|
|
Displays the special registry settings icon if you have made any changes to the DB2 LUW special registry settings using SQL Optimizer. |
Quest Assistant
Connection Information
Temp Table
Special Registry SettingsYou 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.
Toolbar
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
- Select Window | Customize Toolbars
- Select the toolbars you want to show.
- Clear the toolbars you want to hide.
To reset the toolbar to the default
Select Window | Customize Toolbars | Reset Default.