Related reference:
v “db2fs - First steps command” in Command Reference
Verifying the installation using the command line processor (CLP)
You can verify the installation by creating a sample database and running SQL
commands to retrieve sample data.
Prerequisites:
v The sample database component, found in the features selection, must be
installed on your system and is included in a typical installation.
v You require a user with SYSADM authority.
Procedure:
To verify the installation:
1. Log on to the system as a user with SYSADM authority.
2. Start the database manager by entering the db2start command.
3. Enter the db2sampl command to create the SAMPLE database.
This command may take a few minutes to process. There is no completion
message; when the command prompt returns, the process is complete.
The SAMPLE database is automatically cataloged with the database alias SAMPLE
when it is created.
4. Connect to the SAMPLE database, retrieve a list of all the employees that work in
department 20, and reset the database connection. Enter the following
commands from the command line processor (CLP):
connect to sample
"select * from staff where dept = 20"
connect reset
After you have verified the installation, you can remove the SAMPLE database to
free up disk space. Enter the db2 drop database sample command to drop the
SAMPLE database.
Related tasks:
v “Verifying the installation of DB2 servers using First Steps (Linux and
Windows)” on page 23
24 Getting started with DB2 installation and administration
