468 lines
8.4 KiB
HTML
468 lines
8.4 KiB
HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
|
|
<HTML
|
|
><HEAD
|
|
><TITLE
|
|
>Installing DB2 Express-C on Ubuntu 6.06 LTS 'Dapper Drake'</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 Mandriva Linux 2007"
|
|
HREF="mand2007.html"><LINK
|
|
REL="NEXT"
|
|
TITLE="Installing DB2 Express-C on Ubuntu 7.04 'Feisty Fawn'"
|
|
HREF="ubuntu704.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="mand2007.html"
|
|
ACCESSKEY="P"
|
|
>Prev</A
|
|
></TD
|
|
><TD
|
|
WIDTH="80%"
|
|
ALIGN="center"
|
|
VALIGN="bottom"
|
|
></TD
|
|
><TD
|
|
WIDTH="10%"
|
|
ALIGN="right"
|
|
VALIGN="bottom"
|
|
><A
|
|
HREF="ubuntu704.html"
|
|
ACCESSKEY="N"
|
|
>Next</A
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
><HR
|
|
ALIGN="LEFT"
|
|
WIDTH="100%"></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="ubuntu606"
|
|
></A
|
|
>15. Installing DB2 Express-C on Ubuntu 6.06 LTS 'Dapper Drake'</H1
|
|
><P
|
|
> Before proceeding, please ensure that you have read <A
|
|
HREF="planning.html"
|
|
>Section 5</A
|
|
>
|
|
and <A
|
|
HREF="installing.html"
|
|
>Section 6</A
|
|
>.
|
|
</P
|
|
><P
|
|
>These installation notes are based on a single-partition installation
|
|
using the 2.6.15-17 kernel.</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN705"
|
|
></A
|
|
>15.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 6.06 LTS is to
|
|
use the Synaptic package installer, and almost everything is done for you,
|
|
from downloading to installation and configuration. Here's how to do it:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>Under the <B
|
|
CLASS="command"
|
|
>Applications</B
|
|
> menu on the Ubuntu
|
|
menu bar, choose <B
|
|
CLASS="command"
|
|
>Add/Remove</B
|
|
>.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Once the Synaptic package manager application has started up,
|
|
click the <B
|
|
CLASS="command"
|
|
>Show commercial applications</B
|
|
> checkbox.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>In the <B
|
|
CLASS="command"
|
|
>Search</B
|
|
> bar, type "DB2" and hit the Enter
|
|
key.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>DB2 Express should show up as the only result. If you don't see
|
|
it, make sure that Synaptic is displaying <B
|
|
CLASS="command"
|
|
>All
|
|
Applications</B
|
|
> or <B
|
|
CLASS="command"
|
|
>Third party applications</B
|
|
>.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Enable the <B
|
|
CLASS="command"
|
|
>dapper-commercial</B
|
|
> channel if
|
|
requested by clicking the "<B
|
|
CLASS="command"
|
|
>Enable channel</B
|
|
>" button.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Click "<B
|
|
CLASS="command"
|
|
>Apply</B
|
|
>".
|
|
</P
|
|
></LI
|
|
></OL
|
|
>
|
|
After hitting the "<B
|
|
CLASS="command"
|
|
>Apply</B
|
|
>" button, Synaptic will
|
|
download the DB2 Express-C package, along with a few dependent libraries,
|
|
then unpack and install the package and finally configure the DB2 users and
|
|
default instance.
|
|
</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN734"
|
|
></A
|
|
>15.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 and save the changes:
|
|
<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
|
|
></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="mand2007.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="ubuntu704.html"
|
|
ACCESSKEY="N"
|
|
>Next</A
|
|
></TD
|
|
></TR
|
|
><TR
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="left"
|
|
VALIGN="top"
|
|
>Installing DB2 Express-C on Mandriva Linux 2007</TD
|
|
><TD
|
|
WIDTH="34%"
|
|
ALIGN="center"
|
|
VALIGN="top"
|
|
> </TD
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="right"
|
|
VALIGN="top"
|
|
>Installing DB2 Express-C on Ubuntu 7.04 'Feisty Fawn'</TD
|
|
></TR
|
|
></TABLE
|
|
></DIV
|
|
></BODY
|
|
></HTML
|
|
> |