Administration Guide

The Command Center

You can start the Command Center from the Control Center by clicking the Command Center icon on the toolbar.

The Command Center lets you:

• See the resulting output of one or many SQL statements and DB2 commands in a result window. You can scroll through the results and generate a report.
• Create, and save command scripts to the Script Center. You can edit the command script to create new scripts. From the Script Center, the command script can then be scheduled to run as a job at any time that you specify.
• Run SQL statements, DB2 commands and operating system commands. When you run operating DB2 commands from the Command Center, you do not have to precede the command by DB2. You can run operating system commands in any supported operating system script language, such as REXX, by preceding them with an exclamation mark (!). Using the Command Center to run the commands and statements allows you to issue many commands at once, without the need to type and run each command individually.
• Get quick access to the DB2 administration tools, such as the Control Center, from the main toolbar.
• See the access plan and statistics associated with an SQL statement before execution.