Speed-start your Linux App: Using DB2 and the DB2 Control Center

October 30, 2002

How to start and stop DB2 processes, and how to use the DB2 Command Line Processor and Control Center

This article guides you through setting up and using DB2 7.2 with the Command Line Processor. You'll also learn to use the graphical Control Center, which helps you explore and control your databases, and the graphical Command Center, which helps you generate SQL queries. Other topics covered include Java runtime environment setup, useful Linux utility functions, and bash profile customization.

The article covers the following tasks:

• Starting, stopping, and finding DB2 processes
• Creating the Sample database
• Using the DB2 Command Line Processor (CLP)
• Starting the DB2 Control Center with either the Java 1.1.8 or 1.3.1 runtime environment
• Exploring a database using the graphical interface of the DB2 Control Center
• Creating an SQL query using the graphical interface of the DB2 Command Center