Filter
Top Products
Chapter 3. Verifying your installation
Verifying the installation of DB2 servers using First Steps (Linux and
Windows)
You should verify that the DB2 server installation has completed successfully by
accessing data from the SAMPLE database.
Prerequisites:
v You must have the Control Center and the First Steps component installed to
perform this task.
First Steps is listed as a getting started component in the feature selection
window in the DB2 Setup wizard. It is installed as part of a Typical installation
or may be selected when performing a Custom installation.
The Control Center component is only available on Linux (x86 and
AMD64/EM64T only) and Windows.
Procedure:
1. On Linux, log on to the system as the instance owner.
2. On Windows, click Start and, select Programs -> IBM DB2 -> [DB2 Copy Name]
-> Set-up Tools > First Steps. On Linux and Windows, you can start First Steps
by typing the db2fs command.
3. Select Database Creation in the First Steps launchpad. On the Database
Creation page, you will see links to the DB2 Information Center for creating the
SAMPLE database and the Create SAMPLE Database button. Click Create
SAMPLE Database to launch the Create SAMPLE Databases window.
4. You have the options to choose the type of database objects to create and the
database location. You can choose the drive on which to create the SAMPLE
database on Windows, and the directory on which to create the SAMPLE
database on Linux.
5. This command may take a few minutes to process. When the SAMPLE database
has been created, you will receive a completion message. Click OK.
6. Launch the Control Center. On Windows, click Start and, select Programs ->
IBM DB2 -> [DB2 Copy Name] -> General Administration Tools —> Control
Center.. On Linux systems, type the db2cc command
7. In the left pane of the Control Center screen, expand the object tree to view the
SAMPLE database and SAMPLE database objects. Select the Tables object to view
the SAMPLE database tables in the right pane of the Control Center screen.
Right-click on the table name staff and select Query. In the command editor
window, click the run button to execute the query and see the result set.
After you have verified the installation, you can remove the SAMPLE database to
free up disk space. However, you will need to keep the sample database if you
plan to make use of the sample applications.
Enter the db2 drop database sample command to drop the SAMPLE database.
Related tasks:
v “Verifying the installation using the command line processor (CLP)” on page 24
© Copyright IBM Corp. 1993, 2006 23