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