<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML ><HEAD ><TITLE >Installing DB2 Express-C on Ubuntu 7.04 'Feisty Fawn'</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="Installing DB2 Express-C on Ubuntu 6.06 LTS 'Dapper Drake'" HREF="ubuntu606.html"><LINK REL="NEXT" TITLE="Installing DB2 Express-C on SimplyMEPIS 6.0" HREF="mepis6.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="ubuntu606.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="mepis6.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="sect1" ><H1 CLASS="sect1" ><A NAME="ubuntu704" ></A >16. Installing DB2 Express-C on Ubuntu 7.04 'Feisty Fawn'</H1 ><P >These installation notes are based on a single-partition installation using the 2.6.20-16-generic kernel.</P ><P >Note that IBM does not yet officially support this distribution for DB2 9. Any problems you encounter using this distribution must be replicated on a supported distribution before IBM Support can help you resolve the issue.</P ><P >Also be aware that the PowerPC architecture is no longer supported in Ubuntu 7.04 and later.</P ><DIV CLASS="sect2" ><H2 CLASS="sect2" ><A NAME="AEN770" ></A >16.1. Installation notes</H2 ><P >Since you cannot log in as root directly with an Ubuntu system, this DB2 installation is run as the default user created during Ubuntu setup (i.e. the regular user account with 'sudo' capability).</P ><P >There are two ways of installing DB2 Express-C 9 on Ubuntu. The harder of the two methods is to use the default DB2 <B CLASS="command" >db2setup</B >, and then make adjustments to the Ubuntu system afterwards to handle the slight differences of Ubuntu's Debian-based packaging system. For reasons of clarity and brevity, I will omit the instructions for doing it this more difficult way; however, if you would like to see these instructions, please send me an email (db2howto@gmail.com) and I will pass them along.</P ><P >The easy way to install DB2 Express-C on Ubuntu 7.04 is to download the DB2 Express-C Debian package file and then use the Ubuntu package installer. This way, almost everything is done for you, from installation to configuration. Here's how to do it: <P ></P ><OL TYPE="1" ><LI ><P >Use any FTP client software and connect to: <A HREF="" TARGET="_top" >ftp.software.ibm.com/software/data/db2/express/latest_debs</A > </P ></LI ><LI ><P >Download <TT CLASS="filename" >db2exc_9.1.2-1_i386.deb</TT > (or the latest equivalent .deb file) </P ></LI ><LI ><P >Once the download is complete, run this command: <TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><FONT COLOR="#000000" ><PRE CLASS="screen" >sudo gdebi-gtk db2exc_9.1.2-1_i386.deb</PRE ></FONT ></TD ></TR ></TABLE > </P ></LI ><LI ><P >Click "<B CLASS="command" >Install Package</B >"</P ></LI ><LI ><P >Click "<B CLASS="command" >Close</B >" once the package has been installed</P ></LI ></OL > After hitting the "<B CLASS="command" >Install Package</B >" button, the Ubuntu package installer will unpack and install the package and configure the DB2 users and default instance. Click the "<B CLASS="command" >Close</B >" button once the installation is complete. </P ></DIV ><DIV CLASS="sect2" ><H2 CLASS="sect2" ><A NAME="AEN794" ></A >16.2. Post-installation notes</H2 ><P ></P ><P >After installation by Synaptic, there are a few steps required to get DB2 up and running smoothly. <P ></P ><OL TYPE="1" ><LI ><P >Usable passwords for the DB2 default accounts.</P ><P >To actually log in or connect to the DB2 databases and servers using the default DB2 users (db2inst1, db2fenc1, and dasusr1), you need to modify the initial passwords. To do this, open a terminal (as the regular user), and type <B CLASS="command" >sudo su -</B > to get root access. Then run these three commands: <TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><FONT COLOR="#000000" ><PRE CLASS="screen" >passwd db2inst1 passwd db2fenc1 passwd dasusr1</PRE ></FONT ></TD ></TR ></TABLE > Each time you will be asked to set the new password for the specified user account. </P ></LI ><LI ><P >Change the default shell for the DB2 default accounts.</P ><P >The default command shell for the DB2 accounts is set as just a plain old <B CLASS="command" >/bin/sh</B >. To get the handy features of the BASH shell, you'll want to change it for these three accounts. In the same root access command window, open the <TT CLASS="filename" >/etc/passwd</TT > file in your favorite text editor and change: <TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><FONT COLOR="#000000" ><PRE CLASS="screen" > db2inst1:x:1001:1001::/home/db2inst1:/bin/sh db2fenc1:x:1002:1002::/home/db2fenc1:/bin/sh dasusr1:x:1003:1003::/home/dasusr1:/bin/sh</PRE ></FONT ></TD ></TR ></TABLE > to <TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><FONT COLOR="#000000" ><PRE CLASS="screen" > db2inst1:x:1001:1001::/home/db2inst1:/bin/bash db2fenc1:x:1002:1002::/home/db2fenc1:/bin/bash dasusr1:x:1003:1003::/home/dasusr1:/bin/bash</PRE ></FONT ></TD ></TR ></TABLE > </P ></LI ><LI ><P >Enable DB2 service ports for remote connections.</P ><P >To enable outside users to get to your DB2 databases, you'll need to set up the DB2 service port, as it is not configured by the Synaptic installation process.</P ><P >As the regular user, run <B CLASS="command" >sudo vi /etc/services</B > and add this line to the end of the file: <TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><FONT COLOR="#000000" ><PRE CLASS="screen" >db2c_db2inst1 50001/tcp # IBM DB2 instance - db2inst1</PRE ></FONT ></TD ></TR ></TABLE > Then, as the DB2 instance owner (db2inst1 by default), run these commands: <TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><FONT COLOR="#000000" ><PRE CLASS="screen" >db2 update dbm cfg using SVCENAME db2c_db2inst1 db2set DB2COMM=tcpip db2stop db2start</PRE ></FONT ></TD ></TR ></TABLE > Now remote users will be able to connect to the DB2 databases on your Ubuntu system. </P ></LI ><LI ><P >Enable remote DB2 administration connections.</P ><P >To allow remote administration of your DB2 server, you'll need to set up the DB2 DAS connection port, as it is not configured by the Synaptic installation process.</P ><P >As the regular user, run <B CLASS="command" >sudo vi /etc/services</B > and add this line to the end of the file: <TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><FONT COLOR="#000000" ><PRE CLASS="screen" >ibm-db2 523/tcp # IBM DB2 DAS ibm-db2 523/udp # IBM DB2 DAS</PRE ></FONT ></TD ></TR ></TABLE > Then, as the DB2 DAS owner (dasusr1 by default), run these commands: <TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><FONT COLOR="#000000" ><PRE CLASS="screen" >db2admin stop db2admin start</PRE ></FONT ></TD ></TR ></TABLE > Now remote administrators can connect to the DAS server to administer databases on your Ubuntu system. </P ></LI ><LI ><P >Correct instance restart problem</P ><P >One issue of note with the Ubuntu 7.04 installation is that the DB2 instances do not properly restart after a system reboot, and setting DB2AUTOSTART=YES does not resolve the issue.</P ><P >One workaround to this problem was suggested in part by IgorM on the DB2 Express-C forum; and that is to create and execute your own DB2 instance start up script. </P ><P >To begin with, login and create a new script file using the command: <TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><FONT COLOR="#000000" ><PRE CLASS="screen" >sudo vi /etc/init.d/db2</PRE ></FONT ></TD ></TR ></TABLE > and then insert this text: <TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><FONT COLOR="#000000" ><PRE CLASS="screen" >#!/bin/sh # # Script to start DB2 instances on bootup. # set -e . /lib/lsb/init-functions case "$1" in start) /opt/ibm/db2exc/V9.1/instance/db2istrt ;; stop|restart|reload) ;; esac exit 0</PRE ></FONT ></TD ></TR ></TABLE > and write the file to disk with the <B CLASS="command" >:wq</B > vi command. </P ><P > Note that the path to the executable is <B CLASS="command" >/opt/ibm/db2exc/V9.1/</B >, the default installation path from the DB2 .deb file. If your installation put the DB2 files elsewhere, be sure to adjust this script as required to find the /instance/ directory. </P ><P >Once the script has been saved, give the file the proper ownership and permissions: <TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><FONT COLOR="#000000" ><PRE CLASS="screen" >chown root.root db2 chmod 755 db2</PRE ></FONT ></TD ></TR ></TABLE ></P ><P >Now, to initialize this script so that it starts at boot time, install the Boot-Up Manager with this command: <TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><FONT COLOR="#000000" ><PRE CLASS="screen" >sudo apt-get bum</PRE ></FONT ></TD ></TR ></TABLE > </P ><P >After Synaptic downloads and installs the application file, you can run the program by clicking <B CLASS="command" >System -> Administration -> BootUp-Manager</B >. Then click on the "Activate" checkbox beside the <B CLASS="command" >db2</B > entry. Click <B CLASS="command" >Apply</B > and say "No" to the dialog that asks if you want to start the service now. Click <B CLASS="command" >Quit</B >. The script will now run at your next boot and start up all DB2 instances. </P ><P >The only other way to resolve the problem is to manually start the instances after a reboot with <B CLASS="command" >db2start</B > (as the instance owner) and <B CLASS="command" >db2admin start</B > (as the DAS owner). Once DB2 Express-C has passed the validation process for Ubuntu 7.04, this instance start issue will disappear. </P ></LI ></OL > </P ></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="ubuntu606.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="mepis6.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Installing DB2 Express-C on Ubuntu 6.06 LTS 'Dapper Drake'</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" > </TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Installing DB2 Express-C on SimplyMEPIS 6.0</TD ></TR ></TABLE ></DIV ></BODY ></HTML >