246 lines
4.6 KiB
HTML
246 lines
4.6 KiB
HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
|
|
<HTML
|
|
><HEAD
|
|
><TITLE
|
|
>Installing DB2 Express-C on SUSE Linux Enterprise Server (SLES) 9</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 OpenSUSE 10.2"
|
|
HREF="opensuse10.html"><LINK
|
|
REL="NEXT"
|
|
TITLE="Installing DB2 Express-C on SUSE Linux Enterprise Server (SLES) 10"
|
|
HREF="sles10.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="opensuse10.html"
|
|
ACCESSKEY="P"
|
|
>Prev</A
|
|
></TD
|
|
><TD
|
|
WIDTH="80%"
|
|
ALIGN="center"
|
|
VALIGN="bottom"
|
|
></TD
|
|
><TD
|
|
WIDTH="10%"
|
|
ALIGN="right"
|
|
VALIGN="bottom"
|
|
><A
|
|
HREF="sles10.html"
|
|
ACCESSKEY="N"
|
|
>Next</A
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
><HR
|
|
ALIGN="LEFT"
|
|
WIDTH="100%"></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="sles9"
|
|
></A
|
|
>11. Installing DB2 Express-C on SUSE Linux Enterprise Server (SLES) 9</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.5-7.97-default kernel.</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN594"
|
|
></A
|
|
>11.1. Installation notes</H2
|
|
><P
|
|
>The installation on SLES 9 completed successfully, with no problems
|
|
getting the GUI installer working, and no errors during the install. This
|
|
smooth installation isn't surprising, given that SLES 9 is an officially
|
|
supported platform for DB2.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN597"
|
|
></A
|
|
>11.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 YaST 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 setup panel, click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>" and then on the "<B
|
|
CLASS="command"
|
|
>Expert</B
|
|
>
|
|
button. In the ports dialog, add <B
|
|
CLASS="command"
|
|
>523 50001</B
|
|
>. Click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>" until the setup wizard completes and then
|
|
"<B
|
|
CLASS="command"
|
|
>Continue</B
|
|
>" so that YaST will restart the firewall with
|
|
the new configuration. 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="opensuse10.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="sles10.html"
|
|
ACCESSKEY="N"
|
|
>Next</A
|
|
></TD
|
|
></TR
|
|
><TR
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="left"
|
|
VALIGN="top"
|
|
>Installing DB2 Express-C on OpenSUSE 10.2</TD
|
|
><TD
|
|
WIDTH="34%"
|
|
ALIGN="center"
|
|
VALIGN="top"
|
|
> </TD
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="right"
|
|
VALIGN="top"
|
|
>Installing DB2 Express-C on SUSE Linux Enterprise Server (SLES) 10</TD
|
|
></TR
|
|
></TABLE
|
|
></DIV
|
|
></BODY
|
|
></HTML
|
|
> |