248 lines
4.5 KiB
HTML
248 lines
4.5 KiB
HTML
<!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
|
|
> |