Database administration task assistant features

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


Feedback