When you select a database administration command for an
object in the Administration Explorer or the Object
List Editor, a task assistant is displayed.
Each task assistant has four sections that guide you through the
process of setting any options for the selected database administration
command, previewing the generated commands, and running the commands.
- Connection section
- You can expand the Connection section 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 section
- You use the Settings section 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 below the Settings section.
The Command section displays the commands that
are generated based on the input that you specified in the Settings section,
if any. Review the commands in this section before you run them.
In
the
Command section, you can click the following
buttons to take the associated actions:
Table 1. Buttons and their
associated actions in the Command 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 while they run. |
Edit |
Opens the commands in the SQL
and XQuery editor. The SQL and XQuery editor
includes many features for working with the generated commands. In
addition to editing the commands, you can tune the DDL and collect
performance metrics. You can run the commands immediately or export
the commands to a file and run the commands from the file. You
can also start the Job Manager from the SQL and XQuery editor
and schedule a time to run a script that contains the commands.
Use
the toolbar in the SQL and XQuery editor to access
these features.
|
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. |
- Messages section
- The Messages section, which can be expanded
and collapsed, is below the Command section.
When you click Run in the Command section,
the Messages section 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. When 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.