Installing and Configuring DB2 Clients

Using the Command Center

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 operating systems:

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

2. Double-click on the Command Center icon.

To invoke the Command Center on Windows 95 and Windows NT:

1. Click on Start.

2. Select Programs->DB2 for Windows->Command Center.

The Command Center contains a large input area in which you type your commands. To start a command on a new line use the Enter key. 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.

Note:

The semicolon is optional at the end of a single quick command, and at the end of the final command in a series.

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, select the Script icon from the main tool bar.

[ DB2 List of Books | Search the DB2 Books ]