<!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 >