Filter
Top Products
v Display all the command scripts known to the system through the Script
Center, with summary information listed for each.
Start the Command Center in one of the follows ways:
v Click on the Command Center icon in the Control Center.
v Enter the db2cctr command.
v Launch the Command Center from the toolbar as follows:
On Windows 9x or Windows NT
– Click on the Start button and select Programs->DB2 for
Windows->Command Center.
On OS/2
– Click on the OS/2 Warp button and select DB2 for OS/2
–>Command Center.
The Command Center contains a large input area in which you enter your
commands. To run the commands you have entered, click on the Execution
icon (the gears icon), or press CTRL+Enter.
In the Command Center, you do not have to enter a command with
the db2 prefix; instead you just enter the DB2 command. For
example:
list database directory
To enter operating system commands, 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 then Enter key 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.
For example, you could connect to a database called SAMPLE and list all the
system tables by entering the following command:
connect to sample;
list tables for system
After you have clicked on the Execution icon (or pressed CTRL+Enter), the
Command Center switches to 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.
Appendix A. Basic Task Knowledge 135