<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML ><HEAD ><TITLE >Installing DB2 Express-C on SUSE Linux Enterprise Desktop 10</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 Server (SLES) 10" HREF="sles10.html"><LINK REL="NEXT" TITLE="Installing DB2 Express-C on Mandriva Linux 2007" HREF="mand2007.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="sles10.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="mand2007.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="sect1" ><H1 CLASS="sect1" ><A NAME="sled10" ></A >13. Installing DB2 Express-C on SUSE Linux Enterprise Desktop 10</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.16.21-0.25 kernel.</P ><DIV CLASS="sect2" ><H2 CLASS="sect2" ><A NAME="AEN646" ></A >13.1. Installation notes</H2 ><P >The installation on SLED 10 completed successfully, with no problems getting the GUI installer working, and no errors during the install.</P ></DIV ><DIV CLASS="sect2" ><H2 CLASS="sect2" ><A NAME="AEN649" ></A >13.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 add the port values to the firewall using the YaST2 utility.</P ><P >You can use the <B CLASS="command" >db2 get dbm cfg | grep SVCENAME</B > command to retrieve the DB2 instance service name. By default, this is set as a TCP connection at port 50001. Note that you will need to add another new TCP rule to allow firewall access if you create any additional instances later. If you want to remotely administer the DB2 installation on this system, the UDP and TCP connections at port 523 should also be allowed through the firewall.</P ><P >To open these ports using YaST, open the YaST tool, and select "<B CLASS="command" >Security and Users</B >, then select the "<B CLASS="command" >Firewall</B >" icon. In the <B CLASS="command" >Allowed Services</B > setup panel, click on the "<B CLASS="command" >Advanced</B >" button. In the TCP ports dialog, add <B CLASS="command" >523 50001</B >, and in the UDP ports dialog, add <B CLASS="command" >523</B >. Click "<B CLASS="command" >OK</B >" and then "<B CLASS="command" >Next</B >" until the setup wizard completes and restarts the firewall. Remote connections will now pass through to the DB2 instance. </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="sles10.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="mand2007.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Installing DB2 Express-C on SUSE Linux Enterprise Server (SLES) 10</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" > </TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Installing DB2 Express-C on Mandriva Linux 2007</TD ></TR ></TABLE ></DIV ></BODY ></HTML >