Sections in the task assistants

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 assistant
Button 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.


Feedback