306 lines
5.6 KiB
HTML
306 lines
5.6 KiB
HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
|
|
<HTML
|
|
><HEAD
|
|
><TITLE
|
|
>Installing DB2 Express-C on Mandriva Linux 2007</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 SUSE Linux Enterprise Desktop 10"
|
|
HREF="sled10.html"><LINK
|
|
REL="NEXT"
|
|
TITLE="Installing DB2 Express-C on Ubuntu 6.06 LTS 'Dapper Drake'"
|
|
HREF="ubuntu606.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="sled10.html"
|
|
ACCESSKEY="P"
|
|
>Prev</A
|
|
></TD
|
|
><TD
|
|
WIDTH="80%"
|
|
ALIGN="center"
|
|
VALIGN="bottom"
|
|
></TD
|
|
><TD
|
|
WIDTH="10%"
|
|
ALIGN="right"
|
|
VALIGN="bottom"
|
|
><A
|
|
HREF="ubuntu606.html"
|
|
ACCESSKEY="N"
|
|
>Next</A
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
><HR
|
|
ALIGN="LEFT"
|
|
WIDTH="100%"></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="mand2007"
|
|
></A
|
|
>14. Installing DB2 Express-C on Mandriva Linux 2007</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
|
|
>Note that IBM does not 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
|
|
>These installation notes are based on a single-partition installation
|
|
using the 2.6.17-5mdvlegacy kernel.</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN674"
|
|
></A
|
|
>14.1. Installation notes</H2
|
|
><P
|
|
>Note that root logins are not allowed in Mandriva, so you will need to
|
|
log on as another user, then run the <B
|
|
CLASS="command"
|
|
>su -l</B
|
|
> command from a
|
|
terminal session to gain root access before you launch the
|
|
<B
|
|
CLASS="command"
|
|
>./db2setup</B
|
|
> command.
|
|
</P
|
|
><P
|
|
>The only installation error encountered was found when launching the
|
|
<B
|
|
CLASS="command"
|
|
>./db2setup</B
|
|
> command. The screen displayed this error:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>ERROR:
|
|
The following library files could not be loaded by db2langdir
|
|
in /tmp/exp/disk1/db2/linux/install/../bin
|
|
|
|
libstdc++.so.5
|
|
libstdc++.so.5
|
|
|
|
Check the following web site for the up-to-date system
|
|
requirements of IBM DB2 Version 9.1:
|
|
http://www.ibm.com/software/data/db2/udb/sysreqs.html
|
|
|
|
Aborting the current installation ...</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
To resolve this error, use the <B
|
|
CLASS="command"
|
|
>drakrpm</B
|
|
> package utility to
|
|
install the necessary C++ compatibility libraries:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>libstdc++5-3.3.6-3mdk
|
|
libstdc++6-4.1.1-3mdk</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
Installation succeeded after installing the C++ libraries.
|
|
</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN684"
|
|
></A
|
|
>14.2. Post-installation notes</H2
|
|
><P
|
|
>Basic test results (see <A
|
|
HREF="tests.html"
|
|
>Section 21</A
|
|
> for more details) were
|
|
successful.</P
|
|
><P
|
|
>However, I found that after a reboot, the DB2 instance was not being
|
|
restarted automatically, so clients could not connect to the database. To
|
|
correct this problem, execute this command as the instance owner:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2set DB2AUTOSTART=YES</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
This will ensure that the DB2 instance is initialized and ready to receive
|
|
incoming connections after a reboot (intentional or otherwise).</P
|
|
><P
|
|
>Also, to allow DB2 access through the firewall (which
|
|
is enabled by default), it was necessary to modify the add in the
|
|
appropriate firewall ports. To enable external connectivity to your DB2
|
|
server, you must open up TCP and UDP access to ports 523 and TCP access to
|
|
the DB2 instance port (50001 by default).
|
|
</P
|
|
><P
|
|
> Open the Mandriva Control Center, choose the <B
|
|
CLASS="command"
|
|
>Security</B
|
|
>
|
|
tab, and then the "<B
|
|
CLASS="command"
|
|
>Set up a personal firewall...</B
|
|
>" icon.
|
|
In the firewall setup panel, click the "<B
|
|
CLASS="command"
|
|
>Advanced</B
|
|
>
|
|
button and add <B
|
|
CLASS="command"
|
|
>523/udp 523/tcp 50001/tcp</B
|
|
> to the
|
|
<B
|
|
CLASS="command"
|
|
>Other ports</B
|
|
> text box. Click "<B
|
|
CLASS="command"
|
|
>OK</B
|
|
>
|
|
until the firewall setup is complete.
|
|
</P
|
|
><P
|
|
>Note that you will need to add another new TCP rule to allow firewall
|
|
access if you create any additional instances later.</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="sled10.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="ubuntu606.html"
|
|
ACCESSKEY="N"
|
|
>Next</A
|
|
></TD
|
|
></TR
|
|
><TR
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="left"
|
|
VALIGN="top"
|
|
>Installing DB2 Express-C on SUSE Linux Enterprise Desktop 10</TD
|
|
><TD
|
|
WIDTH="34%"
|
|
ALIGN="center"
|
|
VALIGN="top"
|
|
> </TD
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="right"
|
|
VALIGN="top"
|
|
>Installing DB2 Express-C on Ubuntu 6.06 LTS 'Dapper Drake'</TD
|
|
></TR
|
|
></TABLE
|
|
></DIV
|
|
></BODY
|
|
></HTML
|
|
> |