Quick Beginnings for DB2 Universal Database for UNIX

Using the Command Center

On OS/2 and Windows 32-bit operating systems, the Command Center provides an interactive window that allows you to:

• Run SQL statements, DB2 commands, and operating system commands.

• See the execution result of SQL statements and DB2 commands in a results window. You can scroll through the results and save the output to a file.

• Save a sequence of SQL statements and DB2 commands to a script file. You can then schedule the script to run as a job. When a saved script is modified, all jobs dependent on the saved script inherit the new modified behavior.

• Recall and run a script file.

• See the execution plan and statistics associated with a SQL statement before execution. You do this by invoking Visual Explain in the interactive window.

• Get quick access to database administrative tools such as the Control Center and the Journal from the main tool bar.

• Display all the command scripts known to the system through the Script Center, with summary information listed for each.

To invoke the Command Center on OS/2:

1. Double-click on the DB2 for OS/2 folder.

2. Double-click on the Command Center icon.

To invoke the Command Center on Windows 32-bit operating systems:

1. Click on Start, and select Programs->DB2 for Windows-> Command Center.

The Command Center contains a large input area in which you type your commands. To run the commands you have entered, select the Start or stop execution icon from the menu toolbar, or use CTRL+Enter.

It is no longer necessary to enter the commands with a db2 prefix; instead, enter the command as follows: list node directory To enter operating system commands in interactive mode, precede the operating-system command with an exclamation mark (!). For example: !dir

If you want to enter multiple commands, you must end each command with the termination character, then press Enter to start the next command on a new line. (The default termination character is a semicolon(;).) To specify a different termination character, click on the Tools Settings icon in the menu toolbar.

After you enter a command, the Command Center displays the Results window, which informs you how the commands are proceeding.

To recall commands that you have entered, select the Script Tab, click on the drop down box, and select a command. To save commands as scripts, select Script->Save as from the menu bar.

If you want to store commonly used SQL statements or DB2 commands as scripts, click on the Script Center icon from the main tool bar.

[ DB2 List of Books | Search the DB2 Books ]