Quick Beginnings for DB2 Extended Enterprise Edition for UNIX
On OS/2, Windows 95 and Windows NT 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 one or many SQL statements and DB2 commands in
a result 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:
- Double-click the DB2 for OS/2 folder.
- Double-click on the Command Center icon.
To invoke the Command Center on Windows 95 and Windows NT:
- Click on Start.
- 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 bar, or use CTRL+Enter.
|
Do not type the commands with a db2 prefix; instead, enter the
command as follows:
list node directory;
|
If you want to run multiple commands, you must end each command with a
semicolon, then press Enter to start the next command on a new line.
After you run a command, the Command Center displays the Results window,
which informs you how the commands are proceeding.
To recall commands that you have typed in interactive mode, click on the
arrow beside the narrow input window. To save commands entered in
interactive mode 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 icon from the main tool bar.
|
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]