223 lines
3.9 KiB
HTML
223 lines
3.9 KiB
HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
|
|
<HTML
|
|
><HEAD
|
|
><TITLE
|
|
>Installing DB2 Express-C on SimplyMEPIS 6.0</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 7.04 'Feisty Fawn'"
|
|
HREF="ubuntu704.html"><LINK
|
|
REL="NEXT"
|
|
TITLE="Installing the DB2 Information Center"
|
|
HREF="help.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="ubuntu704.html"
|
|
ACCESSKEY="P"
|
|
>Prev</A
|
|
></TD
|
|
><TD
|
|
WIDTH="80%"
|
|
ALIGN="center"
|
|
VALIGN="bottom"
|
|
></TD
|
|
><TD
|
|
WIDTH="10%"
|
|
ALIGN="right"
|
|
VALIGN="bottom"
|
|
><A
|
|
HREF="help.html"
|
|
ACCESSKEY="N"
|
|
>Next</A
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
><HR
|
|
ALIGN="LEFT"
|
|
WIDTH="100%"></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="mepis6"
|
|
></A
|
|
>17. Installing DB2 Express-C on SimplyMEPIS 6.0</H1
|
|
><P
|
|
>SimplyMEPIS 6.0 is based on the Ubuntu package management system and
|
|
repositories, and is currently amongst the top 5 Linux distributions
|
|
(according to distrowatch.com). In 6.0, SimplyMEPIS only supports the 32-bit
|
|
architecture, but the new release, 6.5, supports the 64-bit architecture.</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 32-bit
|
|
installation using the 2.6.15-26.386 kernel.</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN852"
|
|
></A
|
|
>17.1. Installation notes</H2
|
|
><P
|
|
>No problems were encountered during the default installation.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN855"
|
|
></A
|
|
>17.2. Post-installation notes</H2
|
|
><P
|
|
>After installation, I could not create the SAMPLE database, or any
|
|
database for that matter. DB2 returned this strange error:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>SQL0440N No authorized routine named RTRIM of
|
|
type "FUNCTION" having compatible arguments was found</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
I then rebooted and logged back in as root, then opened a terminal session:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>su - db2inst1
|
|
db2sampl</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
and then SAMPLE database creation worked as expected. After this, I logged
|
|
out as root, then back in as db2inst1 and all DB2 tests completed
|
|
successfully.
|
|
</P
|
|
><P
|
|
>If you want to enable external connectivity to your DB2 server,
|
|
you must open up ports 523 and any DB2 instance services (use <B
|
|
CLASS="command"
|
|
>db2
|
|
get dbm cfg | grep SVCENAME</B
|
|
> to retrieve the service names and
|
|
check <TT
|
|
CLASS="filename"
|
|
>/etc/services</TT
|
|
> for the equivalent port values) in your firewall.</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="ubuntu704.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="help.html"
|
|
ACCESSKEY="N"
|
|
>Next</A
|
|
></TD
|
|
></TR
|
|
><TR
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="left"
|
|
VALIGN="top"
|
|
>Installing DB2 Express-C on Ubuntu 7.04 'Feisty Fawn'</TD
|
|
><TD
|
|
WIDTH="34%"
|
|
ALIGN="center"
|
|
VALIGN="top"
|
|
> </TD
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="right"
|
|
VALIGN="top"
|
|
>Installing the DB2 Information Center</TD
|
|
></TR
|
|
></TABLE
|
|
></DIV
|
|
></BODY
|
|
></HTML
|
|
> |