IBM VERSION 9 User Manual
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
24
Getting
started
with
DB2
installation
and
administration