603 lines
8.8 KiB
HTML
603 lines
8.8 KiB
HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
|
|
<HTML
|
|
><HEAD
|
|
><TITLE
|
|
>Installation and operation test plan</TITLE
|
|
><META
|
|
NAME="GENERATOR"
|
|
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
|
|
REL="HOME"
|
|
TITLE="IBM DB2 Express-C for Linux HOWTO"
|
|
HREF="index.html"><LINK
|
|
REL="PREVIOUS"
|
|
TITLE="Using DB2 "
|
|
HREF="using.html"><LINK
|
|
REL="NEXT"
|
|
TITLE="Resources"
|
|
HREF="resources.html"></HEAD
|
|
><BODY
|
|
CLASS="sect1"
|
|
BGCOLOR="#FFFFFF"
|
|
TEXT="#000000"
|
|
LINK="#0000FF"
|
|
VLINK="#840084"
|
|
ALINK="#0000FF"
|
|
><DIV
|
|
CLASS="NAVHEADER"
|
|
><TABLE
|
|
SUMMARY="Header navigation table"
|
|
WIDTH="100%"
|
|
BORDER="0"
|
|
CELLPADDING="0"
|
|
CELLSPACING="0"
|
|
><TR
|
|
><TH
|
|
COLSPAN="3"
|
|
ALIGN="center"
|
|
>IBM DB2 Express-C for Linux HOWTO</TH
|
|
></TR
|
|
><TR
|
|
><TD
|
|
WIDTH="10%"
|
|
ALIGN="left"
|
|
VALIGN="bottom"
|
|
><A
|
|
HREF="using.html"
|
|
ACCESSKEY="P"
|
|
>Prev</A
|
|
></TD
|
|
><TD
|
|
WIDTH="80%"
|
|
ALIGN="center"
|
|
VALIGN="bottom"
|
|
></TD
|
|
><TD
|
|
WIDTH="10%"
|
|
ALIGN="right"
|
|
VALIGN="bottom"
|
|
><A
|
|
HREF="resources.html"
|
|
ACCESSKEY="N"
|
|
>Next</A
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
><HR
|
|
ALIGN="LEFT"
|
|
WIDTH="100%"></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="tests"
|
|
></A
|
|
>21. Installation and operation test plan</H1
|
|
><P
|
|
></P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1031"
|
|
></A
|
|
>21.1. DB2 Express-C installation tests</H2
|
|
><P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>Log on as root (or gain root access through a terminal if a root
|
|
logon is not available)</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Mount the DVD (if installing from Discovery DVD set), or
|
|
download the appropriate Linux compressed image (tar.gz file) from the DB2
|
|
Express-C download site</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Copy the compressed image file to the <TT
|
|
CLASS="filename"
|
|
>/tmp</TT
|
|
>
|
|
directory</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Extract the files from the compressed image, either using the
|
|
Ark GUI tool or using the console command <B
|
|
CLASS="command"
|
|
>tar zxvf
|
|
db2exc_91_LNX_x86.tar.gz</B
|
|
></P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Inside the <TT
|
|
CLASS="filename"
|
|
>/tmp </TT
|
|
> folder, change to the
|
|
<TT
|
|
CLASS="filename"
|
|
>exp/disk1i </TT
|
|
> directory and run the
|
|
<B
|
|
CLASS="command"
|
|
>db2setup</B
|
|
> command:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>./db2setup</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>In the DB2 setup Launchpad, choose <B
|
|
CLASS="command"
|
|
>Install a Product</B
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Choose <B
|
|
CLASS="command"
|
|
>Install New</B
|
|
></P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Click "<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>"</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Verify the license and change the radio button to
|
|
<B
|
|
CLASS="command"
|
|
>Accept</B
|
|
>, then choose
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>" to continue the installation</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Choose a <B
|
|
CLASS="command"
|
|
>Typical</B
|
|
> installation and click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>"</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Verify the install path, or change it to some point on your
|
|
system with at least 470 MB free, click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>"</P
|
|
></LI
|
|
><LI
|
|
>Set up the DAS (DB2 Administration Server) owner account. You
|
|
can use an existing user, or set up a new one (the default user is
|
|
'dasusr1'). Click "<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>"</LI
|
|
><LI
|
|
><P
|
|
>Create a DB2 instance. Click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>"</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Set up the DB2 instance owner account. Again, you can use an
|
|
existing user, or set up a new one (the default instance owner is
|
|
'db2inst1'). Click "<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>"
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Set up the DB2 fenced user account. Same as before, use an
|
|
existing user or set up a new one. Click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>"</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Click "<B
|
|
CLASS="command"
|
|
>Finish</B
|
|
>" to initiate the install</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>If there are any problems with the installation, it will show up
|
|
in the installation log (the log is also kept in the
|
|
<TT
|
|
CLASS="filename"
|
|
>/tmp</TT
|
|
> directory as <TT
|
|
CLASS="filename"
|
|
>db2setup.log</TT
|
|
>
|
|
and <TT
|
|
CLASS="filename"
|
|
>db2setup.err</TT
|
|
>)</P
|
|
></LI
|
|
></OL
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1089"
|
|
></A
|
|
>21.2. DB2 Express-C operation tests</H2
|
|
><P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>Log in as the DB2 instance owner (db2inst1 by default)</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Open a terminal and run 'db2sampl' to create the SAMPLE database</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test terminal based commands:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="a"
|
|
><LI
|
|
>db2 connect to sample</LI
|
|
><LI
|
|
>db2 'select * from dept'</LI
|
|
></OL
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test DB2 Control Center:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="a"
|
|
><LI
|
|
>Open the control center with 'db2cc' command</LI
|
|
><LI
|
|
>Select the "Advanced" view</LI
|
|
><LI
|
|
>Verify the SAMPLE database is present under the "All databases" tab</LI
|
|
><LI
|
|
>Look at the contents of one of the SAMPLE database tables and
|
|
views (e.g. vphone)</LI
|
|
></OL
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Create TOOLS database:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2 'create tools catalog TOOLS create new database TOOLSDB'</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Launch DB2 Task Center:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="a"
|
|
><LI
|
|
>Create a task that issues a simple query like "connect to sample; select tabname from syscat.tables; connect reset;", schedule to run now</LI
|
|
><LI
|
|
>Click on "show results", no errors should exist</LI
|
|
></OL
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Launch DB2 Journal: You should be able to see the results of the
|
|
task you ran in the task center from the Journal.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test DB2 Configuration Assistant
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="a"
|
|
><LI
|
|
><P
|
|
>Start Configuration Assistant from the Control Center, or with <B
|
|
CLASS="command"
|
|
>db2ca</B
|
|
></P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>You should see the SAMPLE database listed, if not, click View, then Refresh.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Right click on the SAMPLE database, choose Change Database,
|
|
then in step 4 of the wizard, register the database as a CLI/ODBC
|
|
source, and catalog as system data source. Click Finish to commit the
|
|
changes</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Right click on the SAMPLE database again, and click on Test
|
|
Connection. Select all types (Standard (ODBC), CLI, JDBC), then type in
|
|
a userid and password, and click on Test Connection. Ensure all tests
|
|
are successful.</P
|
|
></LI
|
|
></OL
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test DB2 trace facility: <B
|
|
CLASS="command"
|
|
>db2trc on</B
|
|
> -- check
|
|
for positive response, then run <B
|
|
CLASS="command"
|
|
>db2trc off</B
|
|
></P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test DB2 problem determination facility: <B
|
|
CLASS="command"
|
|
>db2pd -db
|
|
sample > sample.txt</B
|
|
> (examine output for errors)</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test DB2 license: <B
|
|
CLASS="command"
|
|
>db2licm -l</B
|
|
> should return:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
> Product name: "DB2 Express Edition"
|
|
License type: "Unwarranted"
|
|
Expiry date: "Permanent"
|
|
Product identifier: "db2exp"
|
|
Version information: "9.1"
|
|
Max number of CPUs: "2"
|
|
</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test <B
|
|
CLASS="command"
|
|
>db2dart</B
|
|
>:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2 force applications all
|
|
db2dart sample</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
(should report that DB2DART processing has completed successfully)
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test db2look facility: <B
|
|
CLASS="command"
|
|
>db2look -d sample -e >
|
|
sample.ddl</B
|
|
> (should complete successfully)</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test remote connections:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="a"
|
|
><LI
|
|
><P
|
|
>Create connection through command prompt on DB2 remote
|
|
client system:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2 catalog tcpip node test remote computername server 50001
|
|
db2 catalog db sample at node test</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>From remote machine:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2 connect to sample
|
|
db2 "select * from dept"</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
></OL
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Reboot server and retest via remote connection (to verify DB2
|
|
instance autostart and that any firewall changes stick)
|
|
</P
|
|
></LI
|
|
></OL
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="NAVFOOTER"
|
|
><HR
|
|
ALIGN="LEFT"
|
|
WIDTH="100%"><TABLE
|
|
SUMMARY="Footer navigation table"
|
|
WIDTH="100%"
|
|
BORDER="0"
|
|
CELLPADDING="0"
|
|
CELLSPACING="0"
|
|
><TR
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="left"
|
|
VALIGN="top"
|
|
><A
|
|
HREF="using.html"
|
|
ACCESSKEY="P"
|
|
>Prev</A
|
|
></TD
|
|
><TD
|
|
WIDTH="34%"
|
|
ALIGN="center"
|
|
VALIGN="top"
|
|
><A
|
|
HREF="index.html"
|
|
ACCESSKEY="H"
|
|
>Home</A
|
|
></TD
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="right"
|
|
VALIGN="top"
|
|
><A
|
|
HREF="resources.html"
|
|
ACCESSKEY="N"
|
|
>Next</A
|
|
></TD
|
|
></TR
|
|
><TR
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="left"
|
|
VALIGN="top"
|
|
>Using DB2</TD
|
|
><TD
|
|
WIDTH="34%"
|
|
ALIGN="center"
|
|
VALIGN="top"
|
|
> </TD
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="right"
|
|
VALIGN="top"
|
|
>Resources</TD
|
|
></TR
|
|
></TABLE
|
|
></DIV
|
|
></BODY
|
|
></HTML
|
|
> |