Starting the control center, Entering commands using the command center – IBM GC09-2830-00 User Manual

Page 146

Advertising
background image

Starting the Control Center

Start the Control Center in one of the following ways:

On OS/2

v Enter the db2cc command at a command prompt.

or

v Click on the OS/2 Warp button and select DB2 for OS/2–>Control

Center

.

Note:

You must have the prerequisite Java Runtime Environment
(JRE) level to launch the Control Center using this command.
For more information, refer to the Control Center readme,
which can be found in the x:\sqllib\cc\prime directory,
where x: is drive where you installed your DB2 product.

On Windows 9x or Windows NT

v Enter the db2cc command at a command prompt.

or

v Click on Start and select Programs->DB2 for Windows->Control

Center

.

You can also run the Control Center as an applet through a web
browser. For more information, refer to the Control Center readme,
which can be found in the x:\sqllib\cc\prime directory, where x: is
drive where you installed your DB2 product.

Entering Commands Using the Command Center

This section describes how to enter commands using the Command Center.
The Command Center provides an interactive window to:
v Run SQL statements, DB2 commands, and operating system commands.
v 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.

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

v Recall and run a script file.
v See the execution plan and statistics associated with a SQL statement before

execution. You do this by invoking Visual Explain in the interactive
window.

v Get quick access to database administrative tools from the main tool bar.

134

Quick Beginnings

Advertising