When you select a database administration command for an
object in the Administration Explorer or the Object
List Editor, a task assistant is displayed.
The task assistant guides you through the process of setting any
options for the selected database administration command, previewing
the generated commands, and running the commands. The task assistant
for database administration commands includes four main elements:
- Connection area
- You can expand the Connection area to see
detailed connection information, such as instance name, user name,
connection name, and database name. This information makes it easy
for you to keep track of which connections you are running commands
against.
- Settings area
- You use the Settings area, which is at
the top of the task assistant, to specify options and other input
that might be needed for the command that you want to run. For example,
if want to unload data from a table, you need to specify a location
and file name for the data and the file format that you want used.
Click each tab to review the information on the page and provide any
needed input.
The number of tabs that are displayed varies, depending
on the command that you want to run. For some commands, only one tab
is displayed, and you do not need to specify any additional options.
For other commands, you might need to step through multiple tabs.
- Command section
- The Command section, which can be expanded
and collapsed, is located directly below the Settings area.
The Command section displays the commands that
are generated based on the input that you specified in the Settings area,
if any. Review the commands in this section before you run them.
In
the
Commands section, you can click the following
buttons to take the associated actions:
Table 1. Buttons and their
associated actions in the Commands section of a task assistantButton |
Description and action |
Run |
Issues the commands to the database. The focus
in the task assistant shifts to the Messages section,
where you can monitor the progress of the commands as they run. |
Edit |
Opens the commands in the SQL and
XQuery Editor where you can edit them. Any changes that
you make in the SQL and XQuery Editor are not
saved to or reflected in the Command section.
You can run the changed commands directly from the SQL and
XQuery Editor by using the Run SQL action
that is available when you right-click in the editor. Or, you can
run the commands from the file to which they are saved. |
Save |
Saves the commands to a script that can be run
from a data server. The commands are modified as necessary to be run
from the data server. To use Save, you must
have Optim Database Administrator. |
- Messages section
- The Messages section, which can be expanded
and collapsed, is located directly below the Command section.
When you click Run, you are immediately moved
to the Messages section, which is automatically
expanded if it is in the collapsed state. The progress bar shows the
progress of the commands that are running. In some cases, the progress
bar does not reflect the progress of some commands that might be required
to run the utility. As each command is run, a message is displayed
to provide further information.
If a command fails, the message
number or SQL code and message text are displayed. You can click the
message number or SQL code to open an information center to get more
detailed information about the message.