The Configuration program presents a series of dialogs
to complete a specific task. You respond to prompts or provide necessary
information and proceed to the next step in the process.
Some configuration dialogs are used in a
number of different tasks; however, only the options appropriate for
a specific task are available. In this guide, unavailable options
are explained only if certain conditions cause them to become active.
Most
configuration dialogs include the following items:
- An information (read me) box provides
details and directions to guide you through a step in the configuration
process.
- Dialog-specific elements prompt
for information that is needed to do a selected configuration task.
When a dialog opens, these elements are populated with default entries
or other useful information whenever possible, and the most likely
options are preselected.
- Command buttons control the logical
flow from one dialog to the next.
- The status bar at the bottom of
most configuration dialogs displays one or two boxes when you are
connected to a database. The first box indicates the location of the Optim™ Directory. The second box
is displayed if you are also connected to a DB Alias and indicates
the corresponding information for the DB Alias.
- Each box indicates a DBMS type and a connection
string that is separated by a dash. For Informix®, Sybase ASE, and MS SQL Server,
the connection string is followed by the database name. (The letters
NA following an Informix database
type indicate a Non-ANSI database.)
Command buttons
Here is a list of the most common command
buttons.
- Previous
- Return to the previous dialog. This button is not
present in every dialog.
- Proceed
- Perform any tasks that are initiated by the current
dialog with the information that is provided, close the dialog, and
open the next dialog in sequence.
- Skip
- Skip one or more logically related dialogs or tasks.
This button is not present in every dialog and is sometimes unavailable.
- Undo
- Restore the dialog to its initial status. This button
is not present in every dialog.
- Cancel
- Close the current dialog and return control to the
Configuration main window. This button is present in every dialog.
DBMS terms
The Optim solution supports several
database management systems. Terms that are used in a configuration
dialog reflect the DBMS for the database that is being configured.
For example, when you configure an Oracle database, a configuration
dialog refers to "Packages" to access database tables. However,
when you configure a Sybase ASE or SQL Server database, the same dialog
refers to "Procedures," and for a DB2® database
it refers to "Plans." Varying terms are noted in the description
of a dialog. In some instances, a particular DBMS might require a
unique dialog. In that case, both the common dialog and the unique
dialog are illustrated and described.
Display SQL
If the Configuration program creates data
definition language statements or DDL, the pertinent dialog includes
a check box, Display SQL. To review DDL statements
before they are executed, select this check box. To execute a task
without review, clear the check box.
Note: The Configuration program
creates a text file, sql.txt, containing the
DDL generated during the current and previous sessions. You can browse
or print this file with a text editor, such as Notepad. The file is
generated whether or not you select Display SQL on
a particular dialog and is stored in the default Temp directory.
If you select Display SQL and
click Proceed, the Browse SQL dialog
opens.
The Browse
SQL dialog displays the generated DDL statements in sequence:
- To display the next DDL statement,
select the Display SQL check box, which might
be selected when the dialog opens.
- To execute remaining DDL statements
without review, clear the Display SQL check
box.
Note: The check box to Display SQL is
dynamic. If selected or cleared on one dialog, it automatically changes
on other dialogs, where appropriate.