6702 lines
147 KiB
HTML
6702 lines
147 KiB
HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
|
|
<HTML
|
|
><HEAD
|
|
><TITLE
|
|
>IBM DB2 Express-C for Linux HOWTO</TITLE
|
|
><META
|
|
NAME="GENERATOR"
|
|
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"></HEAD
|
|
><BODY
|
|
CLASS="article"
|
|
BGCOLOR="#FFFFFF"
|
|
TEXT="#000000"
|
|
LINK="#0000FF"
|
|
VLINK="#840084"
|
|
ALINK="#0000FF"
|
|
><DIV
|
|
CLASS="ARTICLE"
|
|
><DIV
|
|
CLASS="TITLEPAGE"
|
|
><H1
|
|
CLASS="title"
|
|
><A
|
|
NAME="AEN2"
|
|
></A
|
|
>IBM DB2 Express-C for Linux HOWTO</H1
|
|
><H3
|
|
CLASS="author"
|
|
><A
|
|
NAME="AEN4"
|
|
>Ian Hakes</A
|
|
></H3
|
|
><DIV
|
|
CLASS="revhistory"
|
|
><TABLE
|
|
WIDTH="100%"
|
|
BORDER="0"
|
|
><TR
|
|
><TH
|
|
ALIGN="LEFT"
|
|
VALIGN="TOP"
|
|
COLSPAN="3"
|
|
><B
|
|
>Revision History</B
|
|
></TH
|
|
></TR
|
|
><TR
|
|
><TD
|
|
ALIGN="LEFT"
|
|
>Revision 2.0</TD
|
|
><TD
|
|
ALIGN="LEFT"
|
|
>2007-07-15</TD
|
|
><TD
|
|
ALIGN="LEFT"
|
|
>Revised by: idmh</TD
|
|
></TR
|
|
><TR
|
|
><TD
|
|
ALIGN="LEFT"
|
|
COLSPAN="3"
|
|
>Complete revision of document to cover DB2 Express-C 9 and new
|
|
Linux distrubution levels</TD
|
|
></TR
|
|
><TR
|
|
><TD
|
|
ALIGN="LEFT"
|
|
>Revision 2.0.1</TD
|
|
><TD
|
|
ALIGN="LEFT"
|
|
>2007-08-22</TD
|
|
><TD
|
|
ALIGN="LEFT"
|
|
>Revised by: idmh</TD
|
|
></TR
|
|
><TR
|
|
><TD
|
|
ALIGN="LEFT"
|
|
COLSPAN="3"
|
|
>Minor update to include instance restart instructions for
|
|
Ubuntu 7.04</TD
|
|
></TR
|
|
></TABLE
|
|
></DIV
|
|
><DIV
|
|
><DIV
|
|
CLASS="abstract"
|
|
><A
|
|
NAME="AEN19"
|
|
></A
|
|
><P
|
|
></P
|
|
><P
|
|
>This HOWTO is intended for anyone interested in installing and
|
|
using the IBM DB2® Express-C 9 database on a Linux® operating
|
|
system. The aim of this document is to provide additional support and
|
|
specific distribution details to get you up and running with DB2 on your
|
|
Linux distribution of choice.</P
|
|
><P
|
|
></P
|
|
></DIV
|
|
></DIV
|
|
><HR></DIV
|
|
><DIV
|
|
CLASS="TOC"
|
|
><DL
|
|
><DT
|
|
><B
|
|
>Table of Contents</B
|
|
></DT
|
|
><DT
|
|
>1. <A
|
|
HREF="#introduction"
|
|
>Introduction</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>1.1. <A
|
|
HREF="#AEN23"
|
|
>Who should read this HOWTO</A
|
|
></DT
|
|
><DT
|
|
>1.2. <A
|
|
HREF="#AEN27"
|
|
>Disclaimer</A
|
|
></DT
|
|
><DT
|
|
>1.3. <A
|
|
HREF="#AEN32"
|
|
>Copyright and license</A
|
|
></DT
|
|
><DT
|
|
>1.4. <A
|
|
HREF="#AEN36"
|
|
>Credits</A
|
|
></DT
|
|
><DT
|
|
>1.5. <A
|
|
HREF="#AEN42"
|
|
>About the author</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>2. <A
|
|
HREF="#whyexpc9"
|
|
>Why DB2 Express-C 9?</A
|
|
></DT
|
|
><DT
|
|
>3. <A
|
|
HREF="#whatsinexpc9"
|
|
>What's included in DB2 Express-C 9</A
|
|
></DT
|
|
><DT
|
|
>4. <A
|
|
HREF="#prerequisites"
|
|
>Prerequisites</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>4.1. <A
|
|
HREF="#AEN69"
|
|
>Hardware requirements</A
|
|
></DT
|
|
><DT
|
|
>4.2. <A
|
|
HREF="#AEN128"
|
|
>Software requirements</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>5. <A
|
|
HREF="#planning"
|
|
>Installation considerations and planning</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>5.1. <A
|
|
HREF="#AEN205"
|
|
>Installation methods</A
|
|
></DT
|
|
><DT
|
|
>5.2. <A
|
|
HREF="#AEN242"
|
|
>User and group setup</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>6. <A
|
|
HREF="#installing"
|
|
>Installing DB2 Express-C</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>6.1. <A
|
|
HREF="#AEN333"
|
|
>db2setup installation</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>7. <A
|
|
HREF="#rhel4"
|
|
>Installing DB2 Express-C on Red Hat Enterprise Linux (RHEL) 4</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>7.1. <A
|
|
HREF="#AEN484"
|
|
>Installation notes</A
|
|
></DT
|
|
><DT
|
|
>7.2. <A
|
|
HREF="#AEN487"
|
|
>Post-installation notes</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>8. <A
|
|
HREF="#fedora6"
|
|
>Installing DB2 Express-C on Fedora Core 6</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>8.1. <A
|
|
HREF="#AEN511"
|
|
>Installation notes</A
|
|
></DT
|
|
><DT
|
|
>8.2. <A
|
|
HREF="#AEN518"
|
|
>Post-installation notes</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>9. <A
|
|
HREF="#fedora7"
|
|
>Installing DB2 Express-C on Fedora 7</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>9.1. <A
|
|
HREF="#AEN538"
|
|
>Installation notes</A
|
|
></DT
|
|
><DT
|
|
>9.2. <A
|
|
HREF="#AEN545"
|
|
>Post-installation notes</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>10. <A
|
|
HREF="#opensuse10"
|
|
>Installing DB2 Express-C on OpenSUSE 10.2</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>10.1. <A
|
|
HREF="#AEN568"
|
|
>Installation notes</A
|
|
></DT
|
|
><DT
|
|
>10.2. <A
|
|
HREF="#AEN571"
|
|
>Post-installation notes</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>11. <A
|
|
HREF="#sles9"
|
|
>Installing DB2 Express-C on SUSE Linux Enterprise Server (SLES) 9</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>11.1. <A
|
|
HREF="#AEN594"
|
|
>Installation notes</A
|
|
></DT
|
|
><DT
|
|
>11.2. <A
|
|
HREF="#AEN597"
|
|
>Post-installation notes</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>12. <A
|
|
HREF="#sles10"
|
|
>Installing DB2 Express-C on SUSE Linux Enterprise Server (SLES) 10</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>12.1. <A
|
|
HREF="#AEN620"
|
|
>Installation notes</A
|
|
></DT
|
|
><DT
|
|
>12.2. <A
|
|
HREF="#AEN623"
|
|
>Post-installation notes</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>13. <A
|
|
HREF="#sled10"
|
|
>Installing DB2 Express-C on SUSE Linux Enterprise Desktop 10</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>13.1. <A
|
|
HREF="#AEN646"
|
|
>Installation notes</A
|
|
></DT
|
|
><DT
|
|
>13.2. <A
|
|
HREF="#AEN649"
|
|
>Post-installation notes</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>14. <A
|
|
HREF="#mand2007"
|
|
>Installing DB2 Express-C on Mandriva Linux 2007</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>14.1. <A
|
|
HREF="#AEN674"
|
|
>Installation notes</A
|
|
></DT
|
|
><DT
|
|
>14.2. <A
|
|
HREF="#AEN684"
|
|
>Post-installation notes</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>15. <A
|
|
HREF="#ubuntu606"
|
|
>Installing DB2 Express-C on Ubuntu 6.06 LTS 'Dapper Drake'</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>15.1. <A
|
|
HREF="#AEN705"
|
|
>Installation notes</A
|
|
></DT
|
|
><DT
|
|
>15.2. <A
|
|
HREF="#AEN734"
|
|
>Post-installation notes</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>16. <A
|
|
HREF="#ubuntu704"
|
|
>Installing DB2 Express-C on Ubuntu 7.04 'Feisty Fawn'</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>16.1. <A
|
|
HREF="#AEN770"
|
|
>Installation notes</A
|
|
></DT
|
|
><DT
|
|
>16.2. <A
|
|
HREF="#AEN794"
|
|
>Post-installation notes</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>17. <A
|
|
HREF="#mepis6"
|
|
>Installing DB2 Express-C on SimplyMEPIS 6.0</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>17.1. <A
|
|
HREF="#AEN852"
|
|
>Installation notes</A
|
|
></DT
|
|
><DT
|
|
>17.2. <A
|
|
HREF="#AEN855"
|
|
>Post-installation notes</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>18. <A
|
|
HREF="#help"
|
|
>Installing the DB2 Information Center</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>18.1. <A
|
|
HREF="#infocenter"
|
|
>Installing the Information Center locally</A
|
|
></DT
|
|
><DT
|
|
>18.2. <A
|
|
HREF="#AEN898"
|
|
>The Information Center daemon</A
|
|
></DT
|
|
><DT
|
|
>18.3. <A
|
|
HREF="#AEN918"
|
|
>Accessing an installed Information Center</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>19. <A
|
|
HREF="#uninstalling"
|
|
>Removing DB2 Express-C</A
|
|
></DT
|
|
><DT
|
|
>20. <A
|
|
HREF="#using"
|
|
>Using DB2</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>20.1. <A
|
|
HREF="#AEN971"
|
|
>DB2 Control Center</A
|
|
></DT
|
|
><DT
|
|
>20.2. <A
|
|
HREF="#AEN989"
|
|
>DB2 Information Center</A
|
|
></DT
|
|
><DT
|
|
>20.3. <A
|
|
HREF="#AEN1008"
|
|
>DB2 command line processor (CLP)</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>21. <A
|
|
HREF="#tests"
|
|
>Installation and operation test plan</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>21.1. <A
|
|
HREF="#AEN1031"
|
|
>DB2 Express-C installation tests</A
|
|
></DT
|
|
><DT
|
|
>21.2. <A
|
|
HREF="#AEN1089"
|
|
>DB2 Express-C operation tests</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>22. <A
|
|
HREF="#resources"
|
|
>Resources</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>22.1. <A
|
|
HREF="#AEN1162"
|
|
>Forums and Newsgroups</A
|
|
></DT
|
|
><DT
|
|
>22.2. <A
|
|
HREF="#AEN1186"
|
|
>Web sites</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>23. <A
|
|
HREF="#gfdl"
|
|
>GNU Free Documentation License</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>23.1. <A
|
|
HREF="#AEN1278"
|
|
>PREAMBLE</A
|
|
></DT
|
|
><DT
|
|
>23.2. <A
|
|
HREF="#AEN1283"
|
|
>APPLICABILITY AND DEFINITIONS</A
|
|
></DT
|
|
><DT
|
|
>23.3. <A
|
|
HREF="#AEN1295"
|
|
>VERBATIM COPYING</A
|
|
></DT
|
|
><DT
|
|
>23.4. <A
|
|
HREF="#AEN1299"
|
|
>COPYING IN QUANTITY</A
|
|
></DT
|
|
><DT
|
|
>23.5. <A
|
|
HREF="#AEN1305"
|
|
>MODIFICATIONS</A
|
|
></DT
|
|
><DT
|
|
>23.6. <A
|
|
HREF="#AEN1343"
|
|
>COMBINING DOCUMENTS</A
|
|
></DT
|
|
><DT
|
|
>23.7. <A
|
|
HREF="#AEN1348"
|
|
>COLLECTIONS OF DOCUMENTS</A
|
|
></DT
|
|
><DT
|
|
>23.8. <A
|
|
HREF="#AEN1352"
|
|
>AGGREGATION WITH INDEPENDENT WORKS</A
|
|
></DT
|
|
><DT
|
|
>23.9. <A
|
|
HREF="#AEN1356"
|
|
>TRANSLATION</A
|
|
></DT
|
|
><DT
|
|
>23.10. <A
|
|
HREF="#AEN1360"
|
|
>TERMINATION</A
|
|
></DT
|
|
><DT
|
|
>23.11. <A
|
|
HREF="#AEN1363"
|
|
>FUTURE REVISIONS OF THIS LICENSE</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>24. <A
|
|
HREF="#trademarks"
|
|
>Trademarks</A
|
|
></DT
|
|
></DL
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="introduction"
|
|
></A
|
|
>1. Introduction</H1
|
|
><DIV
|
|
CLASS="sect2"
|
|
><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN23"
|
|
></A
|
|
>1.1. Who should read this HOWTO</H2
|
|
><P
|
|
>This HOWTO is intended for anyone interested in installing and
|
|
using IBM DB2® Express-C 9 on a Linux® distribution. The goal is
|
|
to include as many distributions as possible, on both 32–bit and
|
|
64–bit architectures, however both hardware and time resources are
|
|
constrained, so if you come across a distribution/architecture combination
|
|
that isn't covered in here or if you encounter a problem that isn't
|
|
addressed, send a note to db2howto@gmail.com and I'll try to help verify or
|
|
resolve your issue and add the information here.</P
|
|
><P
|
|
>The information found in this document is based on personal experiences
|
|
installing and configuring IBM DB2 9 Express-C.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN27"
|
|
></A
|
|
>1.2. Disclaimer</H2
|
|
><P
|
|
>No liability for the contents of this document is accepted.
|
|
Use the concepts, examples and information at your own risk. There may
|
|
be errors and inaccuracies that could be damaging to your system.
|
|
Proceed with caution, and, although it is highly unlikely that accidents
|
|
will happen because of following advice or procedures described in this
|
|
document, the author does not take any responsibility for any damage
|
|
claimed to be caused by this document.</P
|
|
><P
|
|
>All copyrights are held by their by their respective owners,
|
|
unless specifically noted otherwise. Use of a term in this document
|
|
should not be regarded as affecting the validity of any trademark or
|
|
service mark. Naming of particular products or brands should not be seen
|
|
as endorsements.</P
|
|
><P
|
|
>This HOWTO is not official IBM documentation, and cannot be
|
|
construed as such. IBM accepts no responsibility, liability or coverage
|
|
for the material or instructions contained in this HOWTO. The views
|
|
expressed in this document are those of the author, and not IBM
|
|
Corporation.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN32"
|
|
></A
|
|
>1.3. Copyright and license</H2
|
|
><P
|
|
>Copyright (c) 2007 IBM Corporation.</P
|
|
><P
|
|
>Permission is granted to copy, distribute and/or modify this
|
|
document under the terms of the GNU Free Documentation License, Version
|
|
1.2 or any later version published by the Free Software Foundation; with
|
|
the Invariant Sections being "Disclaimer" and "About the Authors". This
|
|
document is distributed in the hope that it will be useful, but WITHOUT
|
|
ANY WARRANTY; without ebaseven the implied warranty of MERCHANTABILITY
|
|
or FITNESS FOR A PARTICULAR PURPOSE. A copy of the license is included
|
|
in the section entitled "GNU Free Documentation License".</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN36"
|
|
></A
|
|
>1.4. Credits</H2
|
|
><P
|
|
>Ian Hakes is the current owner and maintainer of this HOWTO.
|
|
Please send all suggestions for improvement, criticisms or questions to
|
|
db2howto@gmail.com.</P
|
|
><P
|
|
>As always, big thanks to Dan Scott, who continues to be an
|
|
invaluable resource to both myself and the open source community at
|
|
large.</P
|
|
><P
|
|
>I'd also to thank: Rav Ahuja, Boris Bialek, Jason Chan, Ryan Chase,
|
|
Irina Delidjakova, Leon Katsnelson, and Darin McBride for their support,
|
|
input and patience while putting this document together.</P
|
|
><P
|
|
>Most of all, I must thank my wife and children for allowing me to spend
|
|
weeknights and weekends on my laptop and test machines
|
|
getting this document together. I couldn't have done it without their
|
|
love and support.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN42"
|
|
></A
|
|
>1.5. About the author</H2
|
|
><P
|
|
>Ian Hakes, has worked for IBM DB2 since 1999. Currently,
|
|
he is involved in technical marketing for the DB2 Express-C product,
|
|
developing technical documentation and evangelizing DB2 Express-C.
|
|
Before that, he was the technical team lead for the DB2 Information
|
|
Development department, and the writer responsible for the DB2 SQL
|
|
Reference manual. His free time is spent mainly typing on computers,
|
|
thinking about how much nicer it would be to watch a movie or to be
|
|
sailing.</P
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="whyexpc9"
|
|
></A
|
|
>2. Why DB2 Express-C 9?</H1
|
|
><P
|
|
>In March of 2006, IBM made a strategic decision to release their best
|
|
of breed DB2 database as freely available software. It is important to
|
|
realize that the DB2 Express-C edition is a gratis, "free as in beer" software product,
|
|
meaning that, although the source code is not distributed as part of the product,
|
|
this edition of DB2 is freely useable and full featured, not "crippled" in any way.
|
|
</P
|
|
><P
|
|
>A number of other large enterprise class databases have also opted to
|
|
release versions of their software, but DB2 Express-C is the only one that
|
|
places no restrictions on the size or number of the databases that can be
|
|
created. The one restriction to using DB2 Express-C is that it can only be run
|
|
on systems with 2 physical CPUs and 4 GB of RAM. Since the majority of
|
|
developers and small businesses run systems within these specifications, DB2
|
|
Express-C makes a great choice for developers and business applications.
|
|
In this HOWTO, all testing and discussions are based on machines that fall
|
|
within these system specifications.
|
|
</P
|
|
><P
|
|
>With DB2 Express-C, you get a free, low maintenance database application
|
|
that is easy to install and run, with a number of powerful features, as well
|
|
as performance typically found in much more expensive enterprise-level
|
|
database software.
|
|
</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="whatsinexpc9"
|
|
></A
|
|
>3. What's included in DB2 Express-C 9</H1
|
|
><P
|
|
> Feature-wise, what's included in the DB2 Express-C download is impressive. To
|
|
start with, you get the same database engine code as the full enterprise-level
|
|
database server, with no connection restrictions. Also included is the full
|
|
suite of commmand line and graphical user tools to help adminster databases
|
|
and develop database applications. You also get autonomic maintenance features,
|
|
along with development APIs and drivers for C/C++, Java, PHP, Perl and Ruby on
|
|
Rails.
|
|
</P
|
|
><P
|
|
>The cherry on top is the inclusion of IBM's new pureXML™
|
|
hybrid technology that allows you to store XML data natively inside the
|
|
database, without any shredding or decomposition of the data. This is a
|
|
feature that is typically an add-on to the other editions of DB2 9, and IBM is
|
|
giving it to users of the Express-C edition completely free of charge. Sometimes
|
|
it's good to be the little guy.
|
|
</P
|
|
><P
|
|
>There are three architecture choices available for Linux: the 32-bit version, the
|
|
64-bit version, and the PowerPC version, giving you the option of using the best
|
|
hardware you have available for your DB2 installation.
|
|
</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="prerequisites"
|
|
></A
|
|
>4. Prerequisites</H1
|
|
><P
|
|
>Prerequisites are the hardware and software elements needed on your
|
|
system before you can install and use DB2 Express-C 9. This section covers:
|
|
</P
|
|
><P
|
|
></P
|
|
><UL
|
|
><LI
|
|
>Hardware requirements:
|
|
<P
|
|
></P
|
|
><UL
|
|
><LI
|
|
>Supported processors</LI
|
|
><LI
|
|
>Disk space requirements</LI
|
|
><LI
|
|
>Memory requirements</LI
|
|
></UL
|
|
></LI
|
|
><LI
|
|
>Software requirements:
|
|
<P
|
|
></P
|
|
><UL
|
|
><LI
|
|
>Linux distributions</LI
|
|
><LI
|
|
>Kernel levels and libraries requirements</LI
|
|
><LI
|
|
>Additional software requirements</LI
|
|
></UL
|
|
></LI
|
|
></UL
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN69"
|
|
></A
|
|
>4.1. Hardware requirements</H2
|
|
><DIV
|
|
CLASS="sect3"
|
|
><H3
|
|
CLASS="sect3"
|
|
><A
|
|
NAME="AEN71"
|
|
></A
|
|
>4.1.1. Supported processor architectures</H3
|
|
><P
|
|
></P
|
|
><UL
|
|
><LI
|
|
>x86 (32-bit processor)</LI
|
|
><LI
|
|
>x86–64 (64-bit processor)</LI
|
|
><LI
|
|
>POWER™ (any iSeries™ or pSeries® that
|
|
supports Linux)</LI
|
|
></UL
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect3"
|
|
><HR><H3
|
|
CLASS="sect3"
|
|
><A
|
|
NAME="AEN77"
|
|
></A
|
|
>4.1.2. Disk space requirements</H3
|
|
><P
|
|
>Take into account the disk space requirements before you install and
|
|
configure DB2 on your distribution:
|
|
<DIV
|
|
CLASS="table"
|
|
><A
|
|
NAME="AEN80"
|
|
></A
|
|
><P
|
|
><B
|
|
>Table 1. Disk space requirements</B
|
|
></P
|
|
><TABLE
|
|
BORDER="1"
|
|
CLASS="CALSTABLE"
|
|
><THEAD
|
|
><TR
|
|
><TH
|
|
WIDTH="33%"
|
|
ALIGN="LEFT"
|
|
VALIGN="TOP"
|
|
><P
|
|
>Install type</P
|
|
></TH
|
|
><TH
|
|
WIDTH="33%"
|
|
ALIGN="LEFT"
|
|
VALIGN="TOP"
|
|
><P
|
|
>Description</P
|
|
></TH
|
|
><TH
|
|
WIDTH="33%"
|
|
ALIGN="LEFT"
|
|
VALIGN="TOP"
|
|
><P
|
|
>Required disk
|
|
space</P
|
|
></TH
|
|
></TR
|
|
></THEAD
|
|
><TBODY
|
|
><TR
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>Typical</P
|
|
></TD
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>DB2 is installed with most features
|
|
and functionality, including graphical tools such as the Control
|
|
Center.</P
|
|
></TD
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>460 to 560 MB</P
|
|
></TD
|
|
></TR
|
|
><TR
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>Compact</P
|
|
></TD
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>DB2 is installed with basic features
|
|
and functionality, but without the graphical tools.</P
|
|
></TD
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>380 to 460 MB</P
|
|
></TD
|
|
></TR
|
|
><TR
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>Custom</P
|
|
></TD
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>This option allows you to select the
|
|
features and functionality that you want to install.</P
|
|
></TD
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>320 to 820 MB</P
|
|
></TD
|
|
></TR
|
|
></TBODY
|
|
></TABLE
|
|
></DIV
|
|
>
|
|
</P
|
|
><P
|
|
>It's important to allocate enough disk space for the software, along
|
|
with the product documentation (if desired) and the databases you create.
|
|
</P
|
|
><P
|
|
> In DB2 9, product documentation is accessed through the DB2 Information
|
|
Center, either via the web, or as a local system installation. To install
|
|
this locally requires at least 100 MB when installing the core English
|
|
language files. Additional space is required for other additional languages. If
|
|
disk space is an issue, you can configure DB2 to access the Information
|
|
Center from the Web. More detail about this is provided in
|
|
<A
|
|
HREF="#help"
|
|
><I
|
|
>Installing the DB2 Information Center</I
|
|
></A
|
|
>.
|
|
</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect3"
|
|
><HR><H3
|
|
CLASS="sect3"
|
|
><A
|
|
NAME="AEN119"
|
|
></A
|
|
>4.1.3. Memory requirements</H3
|
|
><P
|
|
>We recommend that you should allocate a minimum of 512 MB of RAM for
|
|
DB2 Express-C 9, and additional memory should be allocated for other
|
|
software and communication processes. When determining memory
|
|
requirements, consider the following points:
|
|
<P
|
|
></P
|
|
><UL
|
|
><LI
|
|
>Your SWAP space should be at least twice as much as your RAM.
|
|
</LI
|
|
><LI
|
|
>Additional memory should be allocated for any non-DB2 software
|
|
that may be running on your system.
|
|
</LI
|
|
><LI
|
|
>Additional memory is necessary to support database clients and
|
|
database activity.
|
|
</LI
|
|
><LI
|
|
>These memory requirements will be affected by the size and
|
|
complexity of your database system, as well as specific performance
|
|
requirements.
|
|
</LI
|
|
><LI
|
|
>The maximum RAM allowed for a DB2 Express-C installation is 4 GB.
|
|
</LI
|
|
></UL
|
|
>
|
|
</P
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN128"
|
|
></A
|
|
>4.2. Software requirements</H2
|
|
><DIV
|
|
CLASS="sect3"
|
|
><H3
|
|
CLASS="sect3"
|
|
><A
|
|
NAME="AEN130"
|
|
></A
|
|
>4.2.1. Distribution levels that are supported by DB2 Express-C 9</H3
|
|
><P
|
|
>For a list of all the distributions that are officially
|
|
supported, as well as the latest information about kernels, libraries,
|
|
integrated cluster environments, and papers, visit the <A
|
|
HREF="http://www.ibm.com/software/data/db2/linux/validate/"
|
|
TARGET="_top"
|
|
>DB2 for Linux
|
|
validation</A
|
|
> web site listed in <A
|
|
HREF="#resources"
|
|
><I
|
|
>Resources</I
|
|
></A
|
|
>.
|
|
</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect3"
|
|
><HR><H3
|
|
CLASS="sect3"
|
|
><A
|
|
NAME="AEN135"
|
|
></A
|
|
>4.2.2. Additional software requirements</H3
|
|
><P
|
|
>Depending on your DB2 requirements, you may be required to install
|
|
additional software packages for DB2 to function properly. Make sure that
|
|
these software packages are installed prior to using DB2.
|
|
<P
|
|
></P
|
|
><UL
|
|
><LI
|
|
><P
|
|
>X Window System software, capable of rendering a graphical
|
|
window manager (KDE, Gnome, etc.). You will need this if you want to
|
|
use the DB2 graphical installer, or any of the DB2 graphical
|
|
tools.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>A web browser, to view topics in the DB2 Information
|
|
Center.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>If you are using NIS or NIS+ for security
|
|
authentication on your system, you must create DB2 user accounts
|
|
before installing DB2.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Additional packages, as outlined in the following table:
|
|
<DIV
|
|
CLASS="table"
|
|
><A
|
|
NAME="AEN147"
|
|
></A
|
|
><P
|
|
><B
|
|
>Table 2. Package requirements</B
|
|
></P
|
|
><TABLE
|
|
BORDER="1"
|
|
CLASS="CALSTABLE"
|
|
><THEAD
|
|
><TR
|
|
><TH
|
|
WIDTH="16%"
|
|
ALIGN="LEFT"
|
|
VALIGN="TOP"
|
|
><P
|
|
>Package name</P
|
|
></TH
|
|
><TH
|
|
WIDTH="25%"
|
|
ALIGN="LEFT"
|
|
VALIGN="TOP"
|
|
><P
|
|
>RPM name</P
|
|
></TH
|
|
><TH
|
|
WIDTH="58%"
|
|
ALIGN="LEFT"
|
|
VALIGN="TOP"
|
|
><P
|
|
>Description</P
|
|
></TH
|
|
></TR
|
|
></THEAD
|
|
><TBODY
|
|
><TR
|
|
><TD
|
|
WIDTH="16%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>compat-libstdc++</P
|
|
></TD
|
|
><TD
|
|
WIDTH="25%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>compat-libstdc++</P
|
|
></TD
|
|
><TD
|
|
WIDTH="58%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>Required by 64-bit
|
|
architectures only. Required for backwards compatibility
|
|
with standard C++ libraries used by DB2.</P
|
|
></TD
|
|
></TR
|
|
><TR
|
|
><TD
|
|
WIDTH="16%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>nfs-utils</P
|
|
></TD
|
|
><TD
|
|
WIDTH="25%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>nfs-utils (version 1.0 or later)</P
|
|
></TD
|
|
><TD
|
|
WIDTH="58%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>Network File System support
|
|
package. It allows access for local files to remote
|
|
machines. Required for systems utilizing NFS mounted
|
|
drives.</P
|
|
></TD
|
|
></TR
|
|
></TBODY
|
|
></TABLE
|
|
></DIV
|
|
>
|
|
To check whether you have these packages installed, use the
|
|
<B
|
|
CLASS="command"
|
|
>rpm -q</B
|
|
> commands:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>rpm -qa compat-libstdc++*</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
><P
|
|
>To install these packages on Red Hat Linux, use the Red Hat
|
|
Linux installation CDs and the <B
|
|
CLASS="command"
|
|
>rpm</B
|
|
> command, or
|
|
the <B
|
|
CLASS="command"
|
|
>up2date</B
|
|
> utility. For example, to install
|
|
the compat-libstdc++ package from the Red Hat Linux CD, mount the
|
|
Red Hat Linux CD #4, and enter this command as root:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>rpm -ivh /mnt/cdrom/RedHat/RPMS/compat-libstdc++-296-2.96-132.7.2.i386.rpm</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
To install using the up2date package, run this command as root:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>up2date compat-libstdc++</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
><P
|
|
>To install these packages on SUSE Linux, you can also use
|
|
<B
|
|
CLASS="command"
|
|
>rpm</B
|
|
> or use the handy YaST (Yet another Setup
|
|
Tool) utility. For example, to install nfs-utils on SLES 9
|
|
using YaST:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>Log on as root</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>From the YaST Control Center, select Software ->
|
|
Software Management, then use the search "nfs-utils" to find the
|
|
appropriate packages.</P
|
|
></LI
|
|
></OL
|
|
>
|
|
</P
|
|
></LI
|
|
></UL
|
|
>
|
|
</P
|
|
></DIV
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="planning"
|
|
></A
|
|
>5. Installation considerations and planning</H1
|
|
><P
|
|
>After verifying that your system meets the basic requirements, you should
|
|
plan your installation by considering installation methods and the creation
|
|
of users and groups:
|
|
<P
|
|
></P
|
|
><UL
|
|
><LI
|
|
>Installation choices:
|
|
<P
|
|
></P
|
|
><UL
|
|
><LI
|
|
><B
|
|
CLASS="command"
|
|
>db2setup</B
|
|
>installation</LI
|
|
><LI
|
|
><B
|
|
CLASS="command"
|
|
>db2_install</B
|
|
>installation</LI
|
|
><LI
|
|
>DB2 response file installation</LI
|
|
></UL
|
|
></LI
|
|
><LI
|
|
>User and group setup:
|
|
<P
|
|
></P
|
|
><UL
|
|
><LI
|
|
>User and group requirements</LI
|
|
><LI
|
|
>Creating users</LI
|
|
></UL
|
|
></LI
|
|
></UL
|
|
>
|
|
</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN205"
|
|
></A
|
|
>5.1. Installation methods</H2
|
|
><P
|
|
>After downloading and extracting the tar.gz file, the file tree looks
|
|
like this:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>exp/ -|
|
|
disk1/ -|
|
|
db2_install (* command line installation script *)
|
|
db2setup (* GUI installation launcher *)
|
|
installFixPack (* not applicable for Express-C *)
|
|
db2/ -| (* installation and licensing files *)
|
|
doc/ -| (* install instructions and release notes *)</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
><P
|
|
>You can use three methods to install DB2:
|
|
<P
|
|
></P
|
|
><UL
|
|
><LI
|
|
><P
|
|
><B
|
|
CLASS="command"
|
|
>db2setup</B
|
|
> utility</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
><B
|
|
CLASS="command"
|
|
>db2_install</B
|
|
> utility</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>a DB2 response file</P
|
|
></LI
|
|
></UL
|
|
>
|
|
Each method has its own advantages and disadvantages. The choice of method
|
|
depends on your level of expertise and type of environment, but in
|
|
general, if a graphical interface is available, using
|
|
<B
|
|
CLASS="command"
|
|
>db2setup</B
|
|
> is recommended for ease of installation.
|
|
</P
|
|
><DIV
|
|
CLASS="sect3"
|
|
><HR><H3
|
|
CLASS="sect3"
|
|
><A
|
|
NAME="AEN220"
|
|
></A
|
|
>5.1.1. db2setup installation</H3
|
|
><P
|
|
>The <B
|
|
CLASS="command"
|
|
>db2setup</B
|
|
> command starts the DB2 Launchpad, a
|
|
graphical tool that configures and organizes the DB2 installation. It lays
|
|
down the DB2 filesets, creates and configures DB2 instances, users and
|
|
groups, communications, the administration database used by the DB2 Tools,
|
|
and sets up notification processes. The DB2 Launchpad also allows
|
|
you to create a response file for replicating a particular setup to other
|
|
systems.</P
|
|
><P
|
|
>Using <B
|
|
CLASS="command"
|
|
>db2setup</B
|
|
> is the best method for less
|
|
experienced users, because most of the configuration is automatically
|
|
performed during the installation. As mentioned previously, you require an
|
|
X Window System capable of rendering a graphical user interface to use
|
|
<B
|
|
CLASS="command"
|
|
>db2setup</B
|
|
> successfully.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect3"
|
|
><HR><H3
|
|
CLASS="sect3"
|
|
><A
|
|
NAME="AEN227"
|
|
></A
|
|
>5.1.2. db2_install installation</H3
|
|
><P
|
|
>The <B
|
|
CLASS="command"
|
|
>db2_install</B
|
|
> command script installs all DB2
|
|
packages on your Linux system. This method is reliable and commonly used
|
|
by expert users for installing DB2 on larger, more complex systems.
|
|
However, tasks such as setting up users and groups, creating instances,
|
|
tools catalog database creation, and notification setup need to be
|
|
performed manually after the installation is completed.</P
|
|
><P
|
|
>One limitation to <B
|
|
CLASS="command"
|
|
>db2_install</B
|
|
> is that it only
|
|
installs user assistance (like help, messages, and tool interfaces) in
|
|
English, whereas <B
|
|
CLASS="command"
|
|
>db2setup</B
|
|
> supports the installation of
|
|
additional languages. Also, a <B
|
|
CLASS="command"
|
|
>db2_install</B
|
|
>
|
|
installation can take longer (because of the higher number of manual
|
|
configuration tasks); it requires a higher level of knowledge and skill,
|
|
and it cannot be used to create response files.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect3"
|
|
><HR><H3
|
|
CLASS="sect3"
|
|
><A
|
|
NAME="AEN235"
|
|
></A
|
|
>5.1.3. Response file installation</H3
|
|
><P
|
|
>A response file can be created using the DB2 Setup Wizard or by
|
|
editing an existing DB2 response (.rsp) file. It allows you to install DB2
|
|
across multiple machines with consistent installation and configuration
|
|
settings. A response file installation is fast, because it bypasses the
|
|
graphical wizard configuration. Another advantage of
|
|
using a response file instead of the <B
|
|
CLASS="command"
|
|
>db2_install</B
|
|
>
|
|
command is that it creates a Database Administration Server (DAS) on each
|
|
machine, while with
|
|
<B
|
|
CLASS="command"
|
|
>db2_install</B
|
|
> the DAS must be created manually after
|
|
installation.</P
|
|
><P
|
|
>There is a sample response file (db2exp.rsp) included on the installation image
|
|
that can be modified and used to install DB2, configure users, create
|
|
instances, set up notification, create the tools catalog, and configure a
|
|
large number of database management parameters. This is the quickest
|
|
installation method if you already have all the information you need.
|
|
Unlike
|
|
<B
|
|
CLASS="command"
|
|
>db2setup</B
|
|
>, the response file installation is not
|
|
interactive, and it takes longer to prepare the response file initially.</P
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN242"
|
|
></A
|
|
>5.2. User and group setup</H2
|
|
><P
|
|
>DB2 requires user IDs and groups for database authentication. This
|
|
section discusses these IDs and groups and how to create them.</P
|
|
><DIV
|
|
CLASS="sect3"
|
|
><HR><H3
|
|
CLASS="sect3"
|
|
><A
|
|
NAME="AEN245"
|
|
></A
|
|
>5.2.1. User and group requirements</H3
|
|
><P
|
|
>DB2 requires a minimum of three users and groups: an instance owner,
|
|
a fenced user, and the Database Administration Server (DAS) user. You may
|
|
use the default names provided by the setup utilities, or specify your own
|
|
user and group names. For example, consider the following default user IDs
|
|
and group names produced by the DB2 Setup Launchpad:
|
|
<DIV
|
|
CLASS="table"
|
|
><A
|
|
NAME="AEN248"
|
|
></A
|
|
><P
|
|
><B
|
|
>Table 3. Default user IDs and group names</B
|
|
></P
|
|
><TABLE
|
|
BORDER="1"
|
|
CLASS="CALSTABLE"
|
|
><THEAD
|
|
><TR
|
|
><TH
|
|
WIDTH="25%"
|
|
ALIGN="CENTER"
|
|
VALIGN="MIDDLE"
|
|
> <P
|
|
>Required user</P
|
|
>
|
|
</TH
|
|
><TH
|
|
WIDTH="25%"
|
|
ALIGN="CENTER"
|
|
VALIGN="MIDDLE"
|
|
> <P
|
|
>User name</P
|
|
>
|
|
</TH
|
|
><TH
|
|
WIDTH="25%"
|
|
ALIGN="CENTER"
|
|
VALIGN="MIDDLE"
|
|
> <P
|
|
>Group name</P
|
|
>
|
|
</TH
|
|
><TH
|
|
WIDTH="25%"
|
|
ALIGN="CENTER"
|
|
VALIGN="MIDDLE"
|
|
> <P
|
|
>Description</P
|
|
>
|
|
</TH
|
|
></TR
|
|
></THEAD
|
|
><TBODY
|
|
><TR
|
|
><TD
|
|
WIDTH="25%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>Instance owner</P
|
|
></TD
|
|
><TD
|
|
WIDTH="25%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>db2inst1</P
|
|
></TD
|
|
><TD
|
|
WIDTH="25%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>db2grp1</P
|
|
></TD
|
|
><TD
|
|
WIDTH="25%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>Administers a DB2 instance</P
|
|
></TD
|
|
></TR
|
|
><TR
|
|
><TD
|
|
WIDTH="25%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>Fenced user</P
|
|
></TD
|
|
><TD
|
|
WIDTH="25%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>db2fenc1</P
|
|
></TD
|
|
><TD
|
|
WIDTH="25%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>db2fgrp1</P
|
|
></TD
|
|
><TD
|
|
WIDTH="25%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>Responsible for executing "fenced" user
|
|
defined functions, such as JDFs and stored procedures.</P
|
|
></TD
|
|
></TR
|
|
><TR
|
|
><TD
|
|
WIDTH="25%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>DAS user</P
|
|
></TD
|
|
><TD
|
|
WIDTH="25%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>dasusr1</P
|
|
></TD
|
|
><TD
|
|
WIDTH="25%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>dasadm1</P
|
|
></TD
|
|
><TD
|
|
WIDTH="25%"
|
|
ALIGN="LEFT"
|
|
VALIGN="MIDDLE"
|
|
><P
|
|
>Administers the DB2 Administration
|
|
Server</P
|
|
></TD
|
|
></TR
|
|
></TBODY
|
|
></TABLE
|
|
></DIV
|
|
>
|
|
</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect3"
|
|
><HR><H3
|
|
CLASS="sect3"
|
|
><A
|
|
NAME="AEN293"
|
|
></A
|
|
>5.2.2. Creating users</H3
|
|
><P
|
|
>You must have root authority to create users and groups. There are
|
|
three ways to create a DB2 user ID:
|
|
<P
|
|
></P
|
|
><UL
|
|
><LI
|
|
><P
|
|
>DB2 Launchpad: the DB2 Launchpad installation creates all of
|
|
the required users and groups for you during installation. The
|
|
default users and groups that get created are displayed in the
|
|
table above. This method also gives you the option to specify
|
|
your own user and group names.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Response file: Users can also be created during a response
|
|
file installation if you specify user and group information in the
|
|
response file. For example, consider the following entries in a
|
|
response file that create the three required users and groups for
|
|
DB2:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="programlisting"
|
|
> * DAS user
|
|
DAS_USERNAME = dasusr1
|
|
DAS_GROUP_NAME = dasadm1
|
|
DAS_HOME_DIRECTORY = /home/dasusr1
|
|
DAS_PASSWORD = ******
|
|
* Instance-owning user
|
|
inst1.NAME = db2inst1
|
|
inst1.GROUP_NAME = db2grp1
|
|
inst1.HOME_DIRECTORY = /db2home/db2inst1
|
|
inst1.PASSWORD = ******
|
|
inst1.AUTOSTART = YES
|
|
inst1.AUTHENTICATION = SERVER
|
|
inst1.SVCENAME = db2c_db2inst1
|
|
inst1.PORT_NUMBER = 50001
|
|
inst1.FCM_PORT_NUMBER = 60000
|
|
inst1.MAX_LOGICAL_NODES = 4
|
|
* Fenced user
|
|
nst1.FENCED_USERNAME = db2fenc1
|
|
inst1.FENCED_GROUP_NAME = db2fgrp1
|
|
inst1.FENCED_HOME_DIRECTORY = /db2home/db2fenc1
|
|
inst1.FENCED_PASSWORD = ******</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Manually using command line. To use this method, follow these
|
|
steps:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>Log on to your machine as root.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Create groups for the instance owner, the fenced user
|
|
and the DAS user by using these commands:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>groupadd db2grp1
|
|
groupadd db2fgrp1
|
|
groupadd dasadm1</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
Linux will create the groups using the first available group
|
|
ID (GID) numbers available. You can specify GID numbers if you
|
|
prefer.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Create a user that belongs to each group and specify the
|
|
home directory. For example, you can choose to place all home
|
|
directories in <TT
|
|
CLASS="filename"
|
|
>/db2home</TT
|
|
>
|
|
by entering these commands:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
> useradd -g db2grp1 -m -d /db2home/db2inst1 db2inst1 -p password1
|
|
useradd -g db2fgrp1 -m -d /db2home/db2fenc1 db2fenc1 -p password2
|
|
useradd -g dasadm1 -m -d /db2home/dasusr1 dasusr1 -p password3
|
|
</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
></OL
|
|
>
|
|
</P
|
|
></LI
|
|
></UL
|
|
>
|
|
</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect3"
|
|
><HR><H3
|
|
CLASS="sect3"
|
|
><A
|
|
NAME="AEN314"
|
|
></A
|
|
>5.2.3. Adding existing users as DB2 users</H3
|
|
><P
|
|
>To enable existing system users to act as DB2 instance administrators, you
|
|
must make a few modifications to the existing user accounts:</P
|
|
><P
|
|
></P
|
|
><UL
|
|
><LI
|
|
><P
|
|
>Add your user to the db2grp1 group. The SYSADM_GROUP database
|
|
manager configuration parameter controls who has that level of access
|
|
for all databases in that instance. You can determine what group is
|
|
set as the SYSADM group by entering:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2 get dbm cfg | grep SYSADM_GROUP</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
><P
|
|
>By default, DB2 sets this as the db2grp1 group. To add the user
|
|
to the SYSADM group, modify the <TT
|
|
CLASS="filename"
|
|
>/etc/groups</TT
|
|
> file
|
|
(as root), adding the user account ID to the line for the DB2 system
|
|
admin group. For example:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2grp1:x:102:jackc,ellenp,frankj</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Update the user's profile by adding the following lines to the
|
|
.bashrc file in the home directory
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
># The following three lines have been added by the DB2 SYSADM.
|
|
if [ -f /home/frankj/sqllib/db2profile ]; then
|
|
. /home/frankj/sqllib/db2profile
|
|
fi</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>After installation, if you wish to grant or revoke access to
|
|
databases (or other objects), use the "User and Groups" section of the
|
|
Control Center or the GRANT and REVOKE SQL statements. If you want to
|
|
see an example, by default the SAMPLE database grants a number of
|
|
privileges to "PUBLIC".</P
|
|
></LI
|
|
></UL
|
|
></DIV
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="installing"
|
|
></A
|
|
>6. Installing DB2 Express-C</H1
|
|
><P
|
|
>This chapter covers a typical setup scenario for installing DB2
|
|
Express-C on a 32-bit Linux system, using the <B
|
|
CLASS="command"
|
|
>db2setup</B
|
|
>
|
|
installation method.
|
|
</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN333"
|
|
></A
|
|
>6.1. db2setup installation</H2
|
|
><DIV
|
|
CLASS="sect3"
|
|
><H3
|
|
CLASS="sect3"
|
|
><A
|
|
NAME="AEN335"
|
|
></A
|
|
>6.1.1. Prerequisites</H3
|
|
><P
|
|
> <P
|
|
></P
|
|
><UL
|
|
><LI
|
|
><P
|
|
>Ensure that your system meets the software, memory, and disk
|
|
requirements outlined in <A
|
|
HREF="#planning"
|
|
>Section 5</A
|
|
>.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>You require root authority to perform the installation.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>The DB2 Setup Launchpad is a graphical installer. You must have
|
|
X Window System software capable of rendering a graphical user
|
|
interface for the DB2 Setup Launchpad to run on your machine.</P
|
|
></LI
|
|
></UL
|
|
>
|
|
</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect3"
|
|
><HR><H3
|
|
CLASS="sect3"
|
|
><A
|
|
NAME="AEN346"
|
|
></A
|
|
>6.1.2. Procedure</H3
|
|
><P
|
|
>To install DB2 Express-C 9:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>Log on to the system as a user with root authority.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>If you are installing from a CD or DVD, enter the command to
|
|
mount the DB2 installation media. For example,
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>mount /media/cdrom</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
If you are using a downloaded tar.gz file, extract the contents of
|
|
this archive to a location on your harddrive. For example, presuming
|
|
the tar.gz file was downloaded to the <TT
|
|
CLASS="filename"
|
|
>/tmp</TT
|
|
> directory:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>cd /tmp
|
|
tar zxf db2exc_912_LNX_x86.tar.gz</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Change to the install directory.
|
|
For the CD/DVD install:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>cd /media/cdrom/exp/disk1</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
For the downloaded and extracted tar.gz file:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>cd /tmp/exp/disk1</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Run the <B
|
|
CLASS="command"
|
|
>db2setup</B
|
|
> command.
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>./db2setup</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>When the IBM DB2 Setup Launchpad opens, select "Install a
|
|
Product".</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Select the "<B
|
|
CLASS="command"
|
|
>Install New</B
|
|
>" button in the main
|
|
window.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>When the Welcome to the DB2 Setup wizard window appears, click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>".
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Read the license agreement and select the
|
|
"<B
|
|
CLASS="command"
|
|
>Accept</B
|
|
>" button if you accept the terms (the
|
|
"<B
|
|
CLASS="command"
|
|
>Decline</B
|
|
>" button is selected by default). Click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>".</P
|
|
></LI
|
|
><LI
|
|
>On the <B
|
|
CLASS="command"
|
|
>Select the installation type</B
|
|
>window,
|
|
select the type of installation you want to perform. You have three
|
|
installation options:
|
|
<P
|
|
></P
|
|
><UL
|
|
><LI
|
|
>Typical: 460–560 MB. This option installs and
|
|
configures most of the DB2 components, using a typical
|
|
configuration with default values. This option includes all of the
|
|
core features, along with ODBC support, and commonly used tools
|
|
such as the Control Center. You can select the "<B
|
|
CLASS="command"
|
|
>View
|
|
Features</B
|
|
>" button to see what components get installed
|
|
with this option.
|
|
</LI
|
|
><LI
|
|
>Compact: 380–460 MB. This option installs and
|
|
configures only the basic DB2 components, with minimal
|
|
configuration performed on your computer. With this option you get
|
|
the base server and client support, along with Java and SQL
|
|
procedure support. Again, you can click
|
|
the "<B
|
|
CLASS="command"
|
|
>View Features</B
|
|
>" button for more
|
|
information.
|
|
</LI
|
|
><LI
|
|
>Custom: 320–820 MB. This option allows you to install
|
|
only those components that you select; and to create and customize
|
|
a basic DB2 instance.
|
|
</LI
|
|
></UL
|
|
><P
|
|
>Make your choice and click "<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>". (The remainder
|
|
of these instructions are based on the Custom installation option).
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>On the <B
|
|
CLASS="command"
|
|
>Select the installation action</B
|
|
>
|
|
window, choose the "<B
|
|
CLASS="command"
|
|
>Install DB2 Express on this
|
|
computer</B
|
|
>" radio button. You can also choose to save your
|
|
installations settings in a response file by selecting "<B
|
|
CLASS="command"
|
|
>Save
|
|
your settings in a response file</B
|
|
>". You should choose this
|
|
option if you plan to install DB2, with these same settings, on other
|
|
computers in your environment.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Choose the DB2 elements you want on the <B
|
|
CLASS="command"
|
|
>Select
|
|
the features to install</B
|
|
> window. You can preview each
|
|
component by selecting it and reading the corresponding description in
|
|
the <B
|
|
CLASS="command"
|
|
>Description</B
|
|
> section.</P
|
|
><P
|
|
> You can also choose where to install the DB2 program files. By
|
|
default for a first time installation, this location is <TT
|
|
CLASS="filename"
|
|
>/opt/ibm/db2/V9.1/</TT
|
|
>
|
|
Once you have decided what features you want to install and the
|
|
destination, click "<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>".</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Select what languages you want installed for the messages and
|
|
user interface on your computer in the <B
|
|
CLASS="command"
|
|
>Languages</B
|
|
>
|
|
window. English is always installed, regardless of other language
|
|
choices. Click "<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>".</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>In the <B
|
|
CLASS="command"
|
|
>Specify the location of the DB2 Information
|
|
Center</B
|
|
> window, select how you want to access the DB2
|
|
Information Center. The DB2 Information Center contains documentation
|
|
for DB2 and other related DB2 products. The "<B
|
|
CLASS="command"
|
|
>On the IBM Web
|
|
site</B
|
|
>" button is selected by default. By choosing this
|
|
option, DB2 is configured to access documentation on the Web using your
|
|
browser. If you have a copy of the DB2 Information Center installed
|
|
elsewhere on an intranet server, you can choose the "<B
|
|
CLASS="command"
|
|
>On the
|
|
following intranet server</B
|
|
>" button. Specify the values in
|
|
the <B
|
|
CLASS="command"
|
|
>Host name</B
|
|
> and <B
|
|
CLASS="command"
|
|
>Port
|
|
number</B
|
|
> text fields (the default value for the port number
|
|
is <TT
|
|
CLASS="literal"
|
|
>51000</TT
|
|
>). Click the "<B
|
|
CLASS="command"
|
|
>Help</B
|
|
>"
|
|
button for more information, otherwise click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>".</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Fill out the information for the user that will administer the
|
|
DB2 Administration Server in the <B
|
|
CLASS="command"
|
|
>Set user information for
|
|
the DB2 Administration Server</B
|
|
> window. Select either the
|
|
"<B
|
|
CLASS="command"
|
|
>New user</B
|
|
>" button, or the "<B
|
|
CLASS="command"
|
|
>Existing
|
|
user</B
|
|
>" button. The <B
|
|
CLASS="command"
|
|
>Password</B
|
|
> and
|
|
<B
|
|
CLASS="command"
|
|
>Confirm password</B
|
|
> text boxes are outlined in red
|
|
indicating required fields that must be filled in for the installation
|
|
to continue. If you choose to create a new user, a user account
|
|
will be created (including a home directory) on your Linux system.
|
|
Click "<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>".</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>If you want to create a new basic DB2 instance to store your
|
|
database, then select the "<B
|
|
CLASS="command"
|
|
>Create a DB2 instance</B
|
|
>"
|
|
button on the <B
|
|
CLASS="command"
|
|
>Set up a DB2 instance</B
|
|
> window.
|
|
Otherwise, select the "<B
|
|
CLASS="command"
|
|
>Defer this task until after
|
|
installation is complete</B
|
|
>" button. If you select this
|
|
second option, you will need to create a new instance after the
|
|
installation
|
|
by using the <B
|
|
CLASS="command"
|
|
>db2icrt</B
|
|
> command. Click
|
|
"<B
|
|
CLASS="command"
|
|
>Help</B
|
|
>" for more information, otherwise click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>".</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>If you create a new instance, fill out the information for the
|
|
DB2 instance owner on the <B
|
|
CLASS="command"
|
|
>Set user information for the DB2
|
|
instance owner</B
|
|
> window. Select either the "<B
|
|
CLASS="command"
|
|
>New
|
|
user</B
|
|
>" button, or the "<B
|
|
CLASS="command"
|
|
>Existing user</B
|
|
>"
|
|
button. The <B
|
|
CLASS="command"
|
|
>Password</B
|
|
> and <B
|
|
CLASS="command"
|
|
>Confirm
|
|
password</B
|
|
> text boxes are outlined in red indicating required
|
|
fields that must be filled in for the installation to continue. Again,
|
|
if you choose to create a new user, a user account will be
|
|
created (including a home directory) on your Linux system. Click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>".</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Fill out the information for the DB2 fenced user on the
|
|
<B
|
|
CLASS="command"
|
|
>Set user information for the fenced user</B
|
|
> window.
|
|
Select either the "<B
|
|
CLASS="command"
|
|
>New user</B
|
|
>" button, or the
|
|
"<B
|
|
CLASS="command"
|
|
>Existing user</B
|
|
>" button. The
|
|
<B
|
|
CLASS="command"
|
|
>Password</B
|
|
> and <B
|
|
CLASS="command"
|
|
>Confirm
|
|
password</B
|
|
> text boxes are outlined in red indicating required
|
|
fields that must be filled in for the installation to continue. For
|
|
more information on fenced users, and how fenced users relate to
|
|
fenced and non-fenced user-defined functions (UDFs) and stored
|
|
procedures, click "<B
|
|
CLASS="command"
|
|
>Help</B
|
|
>". Otherwise, click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>" to continue.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Configure the DB2 instance for TCP/IP communications on the
|
|
<B
|
|
CLASS="command"
|
|
>Configure instance IP communication and startup</B
|
|
>
|
|
window. You may either accept the default values found in the
|
|
<B
|
|
CLASS="command"
|
|
>Service name</B
|
|
> and <B
|
|
CLASS="command"
|
|
>Port number</B
|
|
>
|
|
fields, or select your own. If you want to configure the instance
|
|
properties at a later time, select the "<B
|
|
CLASS="command"
|
|
>Do not configure at
|
|
this time</B
|
|
>" button. This service name and port are added to
|
|
the services file for the system, typically found in
|
|
<TT
|
|
CLASS="filename"
|
|
>/etc/services</TT
|
|
>.</P
|
|
><P
|
|
>You can also choose whether to start up
|
|
this instance at system startup. This is recommended if you are
|
|
planning on running your system as a DB2 server. Click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>".</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>On the <B
|
|
CLASS="command"
|
|
>Prepare the DB2 tools catalog</B
|
|
> window,
|
|
select the "<B
|
|
CLASS="command"
|
|
>Prepare the DB2 tools catalog</B
|
|
>" button
|
|
if you want to use the Task Center or Task Scheduler. This option
|
|
creates a local database that stores task metadata. If you do not have
|
|
this task repository, the scheduler will not function. If you want to
|
|
create a DB2 tools catalog after you finish the installation, select
|
|
the "<B
|
|
CLASS="command"
|
|
>Do not prepare the DB2 tools catalog</B
|
|
>"
|
|
button. You can create the DB2 tools catalog later
|
|
manually by using the <B
|
|
CLASS="command"
|
|
>CREATE TOOLS CATALOG</B
|
|
> command.
|
|
Click "<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>".</P
|
|
><P
|
|
>If you decide to create a DB2 tools catalog, you can specify
|
|
which instance, database, and schema in which to store the DB2 tools
|
|
catalog. The DB2 tools catalog will be placed in the home directory of
|
|
the instance owner. Click "<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>".</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Specify a notification mail server and contact list on the
|
|
<B
|
|
CLASS="command"
|
|
>Set up notifications</B
|
|
> window. This allows DB2 to
|
|
notify administrators if a database requires attention.
|
|
Either create a new contact list that is stored locally, or use an
|
|
existing global contact list that resides on a remote DB2 server. Use
|
|
an available SMTP server that will accept an unauthenticated SMTP
|
|
message for e-mail notifications. You may also choose to skip this
|
|
step; DB2 will still record all administration notifications in the
|
|
log files. Click "<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>".</P
|
|
></LI
|
|
><LI
|
|
>If you specified a new local list for contacts in the previous
|
|
step, then in the Specify a contact for health monitor notification, you
|
|
can add a name and email address where DB2 Health Center messages will
|
|
be sent for any health alerts from DB2 databases.
|
|
</LI
|
|
><LI
|
|
><P
|
|
>On the <B
|
|
CLASS="command"
|
|
>Start copying files</B
|
|
> window, review
|
|
the installation settings, and then click
|
|
"<B
|
|
CLASS="command"
|
|
>Finish</B
|
|
>" to complete the installation. The
|
|
<B
|
|
CLASS="command"
|
|
>Current settings</B
|
|
> panel provides a summary of your
|
|
installation and configuration settings.</P
|
|
></LI
|
|
></OL
|
|
>
|
|
While the files are being copied to your computer, you will see two status
|
|
bars on the <B
|
|
CLASS="command"
|
|
>Installing DB2 Express</B
|
|
> window, one
|
|
indicating the progress of each individual installation task, and one for
|
|
the overall installation progress. When the installation is finished, the
|
|
<B
|
|
CLASS="command"
|
|
>Setup Complete</B
|
|
> window indicates what, if any,
|
|
post-installation steps need to be taken, along with a tab (labelled "Log
|
|
File") that shows the log file report for the installation. Click
|
|
"<B
|
|
CLASS="command"
|
|
>Finish</B
|
|
>" to close this window and the Setup
|
|
Launchpad.</P
|
|
></DIV
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="rhel4"
|
|
></A
|
|
>7. Installing DB2 Express-C on Red Hat Enterprise Linux (RHEL) 4</H1
|
|
><P
|
|
>Before proceeding, please ensure that you have read <A
|
|
HREF="#planning"
|
|
>Section 5</A
|
|
> and <A
|
|
HREF="#installing"
|
|
>Section 6</A
|
|
>.
|
|
</P
|
|
><P
|
|
>These installation notes are based on a single-partition installation
|
|
using the 2.6.9-55.0.2 EL kernel.</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN484"
|
|
></A
|
|
>7.1. Installation notes</H2
|
|
><P
|
|
>The installation on Red Hat Enterprise Linux 4 completed successfully,
|
|
with no problems getting the GUI installer working, and no errors
|
|
during the install. This smooth installation isn't surprising, given that
|
|
RHEL 4 is an officially supported platform for DB2.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN487"
|
|
></A
|
|
>7.2. Post-installation notes</H2
|
|
><P
|
|
>Basic test results (see <A
|
|
HREF="#tests"
|
|
>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 iptables-based firewall (which
|
|
is enabled by default), it was necessary to modify the iptables firewall
|
|
ruleset, which is kept in the <TT
|
|
CLASS="filename"
|
|
>/etc/sysconfig/iptables</TT
|
|
>
|
|
file. If you have enabled your firewall (using the
|
|
<B
|
|
CLASS="command"
|
|
>iptables</B
|
|
> service), and you want to enable external
|
|
connectivity to your DB2 server, you must open up TCP and UDP access to
|
|
ports 523 and TCP access to any DB2 service ports. To make this work, add
|
|
these rules to the <TT
|
|
CLASS="filename"
|
|
>iptables</TT
|
|
>file (anywhere amongst the
|
|
<B
|
|
CLASS="command"
|
|
>-j ACCEPT</B
|
|
> rules):
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>-A RH-Firewall-1-INPUT -p udp -m udp --dport 523 -j ACCEPT
|
|
-A RH-Firewall-1-INPUT -p tcp -m tcp --dport 523 -j ACCEPT
|
|
-A RH-Firewall-1-INPUT -p tcp -m tcp --dport 50000 -j ACCEPT</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
These rules were added directly to the <TT
|
|
CLASS="filename"
|
|
>iptables</TT
|
|
> file to
|
|
ensure that they persist in case of a system reboot. Note that you will need
|
|
to add another new TCP rule to allow firewall access if you create any
|
|
additional instances later.
|
|
</P
|
|
><P
|
|
>You can use <B
|
|
CLASS="command"
|
|
>db2 get dbm cfg | grep SVCENAME</B
|
|
> to retrieve
|
|
the service names and then check the <TT
|
|
CLASS="filename"
|
|
>/etc/services</TT
|
|
> for
|
|
the equivalent port values to open on your firewall.</P
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="fedora6"
|
|
></A
|
|
>8. Installing DB2 Express-C on Fedora Core 6</H1
|
|
><P
|
|
> Before proceeding, please ensure that you have read
|
|
<A
|
|
HREF="#planning"
|
|
>Section 5</A
|
|
> and <A
|
|
HREF="#installing"
|
|
>Section 6</A
|
|
>.
|
|
</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. See the DB2 Linux validation website in <A
|
|
HREF="#resources"
|
|
>Section 22</A
|
|
>.</P
|
|
><P
|
|
>These installation notes are based on a single-partition 32-bit
|
|
installation using the 2.6.18-1.2849.fc6 kernel.</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN511"
|
|
></A
|
|
>8.1. Installation notes</H2
|
|
><P
|
|
>The only installation error encountered was found when launching the
|
|
<B
|
|
CLASS="command"
|
|
>./db2setup</B
|
|
> command. The screen displayed this error:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>ERROR:
|
|
The following library files could not be loaded by db2langdir
|
|
in /tmp/exp/disk1/db2/linux/install/../bin
|
|
|
|
libstdc++.so.5
|
|
libstdc++.so.5
|
|
|
|
Check the following web site for the up-to-date system
|
|
requirements of IBM DB2 Version 9.1:
|
|
http://www.ibm.com/software/data/db2/udb/sysreqs.html
|
|
|
|
Aborting the current installation ...</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
To resolve this error, use the <B
|
|
CLASS="command"
|
|
>yum</B
|
|
> package utility to
|
|
install the necessary C++ compatibility libraries:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>yum -y install compat-libstdc++-33</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
Installation succeeded after installing the C++ libraries.
|
|
</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN518"
|
|
></A
|
|
>8.2. Post-installation notes</H2
|
|
><P
|
|
>Test results (see <A
|
|
HREF="#tests"
|
|
>Section 21</A
|
|
> for more details) were
|
|
successful, except the Configuration Assistant was very slow when launched
|
|
from the DB2 Control Center. I eventually had to kill the process and it
|
|
returned a DB2JAVIT : RC = 143 return code.
|
|
</P
|
|
><P
|
|
>One strange effect encountered was that DB2 windows were not showing
|
|
up when launching the Java-based GUI tools (and other windows were missing
|
|
window decoration); however, logging off and then back in again solved the
|
|
problem.</P
|
|
><P
|
|
>To inherit the DB2 instance environment from another home directory,
|
|
create databases, dynamically load the DB2 libraries, and other tasks, I
|
|
found that I had to either disable SELinux or modify the default SELinux
|
|
policies. You can disable SELinux at run-time by running the following
|
|
command as root:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
># /usr/sbin/setenforce 0</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
Note that when you reboot SELinux will be enabled again. To disable SELinux
|
|
permanently, edit <TT
|
|
CLASS="filename"
|
|
>/etc/selinux/config</TT
|
|
> and set the
|
|
following value:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>SELINUX=disabled</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
><P
|
|
>If you have enabled your firewall (using the <B
|
|
CLASS="command"
|
|
>iptables</B
|
|
>
|
|
service), and you want to enable external connectivity to your DB2 server,
|
|
you must open up ports 523 and any DB2 service ports (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="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="fedora7"
|
|
></A
|
|
>9. Installing DB2 Express-C on Fedora 7</H1
|
|
><P
|
|
> Before proceeding, please ensure that you have read
|
|
<A
|
|
HREF="#planning"
|
|
>Section 5</A
|
|
> and <A
|
|
HREF="#installing"
|
|
>Section 6</A
|
|
>.
|
|
</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.21-1.3228.fc7 kernel.</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN538"
|
|
></A
|
|
>9.1. Installation notes</H2
|
|
><P
|
|
>The only installation error encountered was found when launching the
|
|
<B
|
|
CLASS="command"
|
|
>./db2setup</B
|
|
> command. The screen displayed this error:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>ERROR:
|
|
The following library files could not be loaded by db2langdir
|
|
in /tmp/exp/disk1/db2/linux/install/../bin
|
|
|
|
libstdc++.so.5
|
|
libstdc++.so.5
|
|
|
|
Check the following web site for the up-to-date system
|
|
requirements of IBM DB2 Version 9.1:
|
|
http://www.ibm.com/software/data/db2/udb/sysreqs.html
|
|
|
|
Aborting the current installation ...</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
To resolve this error, use the <B
|
|
CLASS="command"
|
|
>yum</B
|
|
> package utility to install the necessary C++ compatibility libraries:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>yum -y install compat-libstdc++-33</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
Installation succeeded after installing the C++ libraries.
|
|
</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN545"
|
|
></A
|
|
>9.2. Post-installation notes</H2
|
|
><P
|
|
>Basic test results (see <A
|
|
HREF="#tests"
|
|
>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 iptables-based firewall (which
|
|
is enabled by default), it was necessary to modify the iptables firewall
|
|
ruleset, which is kept in the <TT
|
|
CLASS="filename"
|
|
>/etc/sysconfig/iptables</TT
|
|
>
|
|
file. If you have enabled your firewall (using the
|
|
<B
|
|
CLASS="command"
|
|
>iptables</B
|
|
> service), and you want to enable external
|
|
connectivity to your DB2 server, you must open up TCP and UDP access to
|
|
ports 523 and TCP access to any DB2 service ports. To make this work, add
|
|
these rules to the <TT
|
|
CLASS="filename"
|
|
>iptables</TT
|
|
>file (anywhere amongst the
|
|
<B
|
|
CLASS="command"
|
|
>-j ACCEPT</B
|
|
> rules):
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>-A RH-Firewall-1-INPUT -p udp -m udp --dport 523 -j ACCEPT
|
|
-A RH-Firewall-1-INPUT -p tcp -m tcp --dport 523 -j ACCEPT
|
|
-A RH-Firewall-1-INPUT -p tcp -m tcp --dport 50000 -j ACCEPT</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
These rules were added directly to the <TT
|
|
CLASS="filename"
|
|
>iptables</TT
|
|
> file to
|
|
ensure that they persist in case of a system reboot. Note that you will need
|
|
to add another new TCP rule to allow firewall access if you create any
|
|
additional instances later.
|
|
</P
|
|
><P
|
|
>You can use <B
|
|
CLASS="command"
|
|
>db2 get dbm cfg | grep SVCENAME</B
|
|
> to retrieve
|
|
the service names and then check the <TT
|
|
CLASS="filename"
|
|
>/etc/services</TT
|
|
> for
|
|
the equivalent port values to open on your firewall.</P
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="opensuse10"
|
|
></A
|
|
>10. Installing DB2 Express-C on OpenSUSE 10.2</H1
|
|
><P
|
|
>Before proceeding, please ensure that you have read <A
|
|
HREF="#planning"
|
|
>Section 5</A
|
|
> and <A
|
|
HREF="#installing"
|
|
>Section 6</A
|
|
>.</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 installation
|
|
using the 2.6.18.2-34-default kernel.</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN568"
|
|
></A
|
|
>10.1. Installation notes</H2
|
|
><P
|
|
>The installation on OpenSUSE 10.2 completed successfully,
|
|
with no problems getting the GUI installer working, and no errors
|
|
during the install.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN571"
|
|
></A
|
|
>10.2. Post-installation notes</H2
|
|
><P
|
|
>Basic test results (see <A
|
|
HREF="#tests"
|
|
>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"
|
|
>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="sect1"
|
|
><HR><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"
|
|
>Section 5</A
|
|
> and <A
|
|
HREF="#installing"
|
|
>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"
|
|
><HR><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"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN597"
|
|
></A
|
|
>11.2. Post-installation notes</H2
|
|
><P
|
|
>Basic test results (see <A
|
|
HREF="#tests"
|
|
>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="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="sles10"
|
|
></A
|
|
>12. Installing DB2 Express-C on SUSE Linux Enterprise Server (SLES) 10</H1
|
|
><P
|
|
>Before proceeding, please ensure that you have read <A
|
|
HREF="#planning"
|
|
>Section 5</A
|
|
> and <A
|
|
HREF="#installing"
|
|
>Section 6</A
|
|
>.</P
|
|
><P
|
|
>These installation notes are based on a single-partition installation
|
|
using the 2.6.16.21-0.8-default kernel. Novell AppArmor security was installed
|
|
and enabled during the installation and testing.</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN620"
|
|
></A
|
|
>12.1. Installation notes</H2
|
|
><P
|
|
>The installation on SLES 10 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 10 is an officially supported platform for DB2.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN623"
|
|
></A
|
|
>12.2. Post-installation notes</H2
|
|
><P
|
|
>Basic test results (see <A
|
|
HREF="#tests"
|
|
>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"
|
|
>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="sect1"
|
|
><HR><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"
|
|
>Section 5</A
|
|
> and <A
|
|
HREF="#installing"
|
|
>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"
|
|
><HR><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"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN649"
|
|
></A
|
|
>13.2. Post-installation notes</H2
|
|
><P
|
|
>Basic test results (see <A
|
|
HREF="#tests"
|
|
>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="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="mand2007"
|
|
></A
|
|
>14. Installing DB2 Express-C on Mandriva Linux 2007</H1
|
|
><P
|
|
> Before proceeding, please ensure that you have read <A
|
|
HREF="#planning"
|
|
>Section 5</A
|
|
>
|
|
and <A
|
|
HREF="#installing"
|
|
>Section 6</A
|
|
>.
|
|
</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 installation
|
|
using the 2.6.17-5mdvlegacy kernel.</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN674"
|
|
></A
|
|
>14.1. Installation notes</H2
|
|
><P
|
|
>Note that root logins are not allowed in Mandriva, so you will need to
|
|
log on as another user, then run the <B
|
|
CLASS="command"
|
|
>su -l</B
|
|
> command from a
|
|
terminal session to gain root access before you launch the
|
|
<B
|
|
CLASS="command"
|
|
>./db2setup</B
|
|
> command.
|
|
</P
|
|
><P
|
|
>The only installation error encountered was found when launching the
|
|
<B
|
|
CLASS="command"
|
|
>./db2setup</B
|
|
> command. The screen displayed this error:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>ERROR:
|
|
The following library files could not be loaded by db2langdir
|
|
in /tmp/exp/disk1/db2/linux/install/../bin
|
|
|
|
libstdc++.so.5
|
|
libstdc++.so.5
|
|
|
|
Check the following web site for the up-to-date system
|
|
requirements of IBM DB2 Version 9.1:
|
|
http://www.ibm.com/software/data/db2/udb/sysreqs.html
|
|
|
|
Aborting the current installation ...</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
To resolve this error, use the <B
|
|
CLASS="command"
|
|
>drakrpm</B
|
|
> package utility to
|
|
install the necessary C++ compatibility libraries:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>libstdc++5-3.3.6-3mdk
|
|
libstdc++6-4.1.1-3mdk</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
Installation succeeded after installing the C++ libraries.
|
|
</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN684"
|
|
></A
|
|
>14.2. Post-installation notes</H2
|
|
><P
|
|
>Basic test results (see <A
|
|
HREF="#tests"
|
|
>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 modify the add in the
|
|
appropriate firewall ports. To enable external connectivity to your DB2
|
|
server, you must open up TCP and UDP access to ports 523 and TCP access to
|
|
the DB2 instance port (50001 by default).
|
|
</P
|
|
><P
|
|
> Open the Mandriva Control Center, choose the <B
|
|
CLASS="command"
|
|
>Security</B
|
|
>
|
|
tab, and then the "<B
|
|
CLASS="command"
|
|
>Set up a personal firewall...</B
|
|
>" icon.
|
|
In the firewall setup panel, click the "<B
|
|
CLASS="command"
|
|
>Advanced</B
|
|
>
|
|
button and add <B
|
|
CLASS="command"
|
|
>523/udp 523/tcp 50001/tcp</B
|
|
> to the
|
|
<B
|
|
CLASS="command"
|
|
>Other ports</B
|
|
> text box. Click "<B
|
|
CLASS="command"
|
|
>OK</B
|
|
>
|
|
until the firewall setup is complete.
|
|
</P
|
|
><P
|
|
>Note that you will need to add another new TCP rule to allow firewall
|
|
access if you create any additional instances later.</P
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="ubuntu606"
|
|
></A
|
|
>15. Installing DB2 Express-C on Ubuntu 6.06 LTS 'Dapper Drake'</H1
|
|
><P
|
|
> Before proceeding, please ensure that you have read <A
|
|
HREF="#planning"
|
|
>Section 5</A
|
|
>
|
|
and <A
|
|
HREF="#installing"
|
|
>Section 6</A
|
|
>.
|
|
</P
|
|
><P
|
|
>These installation notes are based on a single-partition installation
|
|
using the 2.6.15-17 kernel.</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN705"
|
|
></A
|
|
>15.1. Installation notes</H2
|
|
><P
|
|
>Since you cannot log in as root directly with an Ubuntu system, this
|
|
DB2 installation is run as the default user created during Ubuntu
|
|
setup (i.e. the regular user account with 'sudo' capability).</P
|
|
><P
|
|
>There are two ways of installing DB2 Express-C 9 on Ubuntu. The harder
|
|
of the two methods is to use the default DB2 <B
|
|
CLASS="command"
|
|
>db2setup</B
|
|
>,
|
|
and then make adjustments to the Ubuntu system afterwards to handle the
|
|
slight differences of Ubuntu's Debian-based packaging system. For
|
|
reasons of clarity and brevity, I will omit the instructions for doing it
|
|
this more difficult way; however, if you would like to see these
|
|
instructions, please send me an email (db2howto@gmail.com) and I will
|
|
pass them along.</P
|
|
><P
|
|
>The easy way to install DB2 Express-C on Ubuntu 6.06 LTS is to
|
|
use the Synaptic package installer, and almost everything is done for you,
|
|
from downloading to installation and configuration. Here's how to do it:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>Under the <B
|
|
CLASS="command"
|
|
>Applications</B
|
|
> menu on the Ubuntu
|
|
menu bar, choose <B
|
|
CLASS="command"
|
|
>Add/Remove</B
|
|
>.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Once the Synaptic package manager application has started up,
|
|
click the <B
|
|
CLASS="command"
|
|
>Show commercial applications</B
|
|
> checkbox.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>In the <B
|
|
CLASS="command"
|
|
>Search</B
|
|
> bar, type "DB2" and hit the Enter
|
|
key.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>DB2 Express should show up as the only result. If you don't see
|
|
it, make sure that Synaptic is displaying <B
|
|
CLASS="command"
|
|
>All
|
|
Applications</B
|
|
> or <B
|
|
CLASS="command"
|
|
>Third party applications</B
|
|
>.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Enable the <B
|
|
CLASS="command"
|
|
>dapper-commercial</B
|
|
> channel if
|
|
requested by clicking the "<B
|
|
CLASS="command"
|
|
>Enable channel</B
|
|
>" button.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Click "<B
|
|
CLASS="command"
|
|
>Apply</B
|
|
>".
|
|
</P
|
|
></LI
|
|
></OL
|
|
>
|
|
After hitting the "<B
|
|
CLASS="command"
|
|
>Apply</B
|
|
>" button, Synaptic will
|
|
download the DB2 Express-C package, along with a few dependent libraries,
|
|
then unpack and install the package and finally configure the DB2 users and
|
|
default instance.
|
|
</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN734"
|
|
></A
|
|
>15.2. Post-installation notes</H2
|
|
><P
|
|
></P
|
|
><P
|
|
>After installation by Synaptic, there are a few steps required to get
|
|
DB2 up and running smoothly.
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>Usable passwords for the DB2 default accounts.</P
|
|
><P
|
|
>To actually log in or connect to the DB2 databases and servers using
|
|
the default DB2 users (db2inst1, db2fenc1, and dasusr1), you need to
|
|
modify the initial passwords. To do this, open a terminal (as the regular
|
|
user), and type <B
|
|
CLASS="command"
|
|
>sudo su -</B
|
|
> to get root access. Then run
|
|
these three commands:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>passwd db2inst1
|
|
passwd db2fenc1
|
|
passwd dasusr1</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
Each time you will be asked to set the new password for the specified user
|
|
account.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Change the default shell for the DB2 default accounts.</P
|
|
><P
|
|
>The default command shell for the DB2 accounts is set as just a
|
|
plain old <B
|
|
CLASS="command"
|
|
>/bin/sh</B
|
|
>. To get the handy features of the
|
|
BASH shell, you'll want to change it for these three accounts. In the same
|
|
root access command window, open the <TT
|
|
CLASS="filename"
|
|
>/etc/passwd</TT
|
|
> file
|
|
in your favorite text editor and change:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
> db2inst1:x:1001:1001::/home/db2inst1:/bin/sh
|
|
db2fenc1:x:1002:1002::/home/db2fenc1:/bin/sh
|
|
dasusr1:x:1003:1003::/home/dasusr1:/bin/sh</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
to
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
> db2inst1:x:1001:1001::/home/db2inst1:/bin/bash
|
|
db2fenc1:x:1002:1002::/home/db2fenc1:/bin/bash
|
|
dasusr1:x:1003:1003::/home/dasusr1:/bin/bash</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Enable DB2 service ports for remote connections.</P
|
|
><P
|
|
>To enable outside users to get to your DB2 databases, you'll need
|
|
to set up the DB2 service port, as it is not configured by the Synaptic
|
|
installation process.</P
|
|
><P
|
|
>As the regular user, run <B
|
|
CLASS="command"
|
|
>sudo vi /etc/services</B
|
|
>
|
|
and add this line to the end of the file and save the changes:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2c_db2inst1 50001/tcp # IBM DB2 instance - db2inst1</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
Then, as the DB2 instance owner (db2inst1 by default), run these commands:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2 update dbm cfg using SVCENAME db2c_db2inst1
|
|
db2set DB2COMM=tcpip
|
|
db2stop
|
|
db2start</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
Now remote users will be able to connect to the DB2 databases on your
|
|
Ubuntu system.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Enable remote DB2 administration connections.</P
|
|
><P
|
|
>To allow remote administration of your DB2 server, you'll need to
|
|
set up the DB2 DAS connection port, as it is not configured by the
|
|
Synaptic installation process.
|
|
</P
|
|
><P
|
|
>As the regular user, run <B
|
|
CLASS="command"
|
|
>sudo vi /etc/services</B
|
|
>
|
|
and add this line to the end of the file:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>ibm-db2 523/tcp # IBM DB2 DAS
|
|
ibm-db2 523/udp # IBM DB2 DAS</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
Then, as the DB2 DAS owner (dasusr1 by default), run these commands:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2admin stop
|
|
db2admin start</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
Now remote administrators can connect to the DAS server to administer
|
|
databases on your Ubuntu system.
|
|
</P
|
|
></LI
|
|
></OL
|
|
>
|
|
</P
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="ubuntu704"
|
|
></A
|
|
>16. Installing DB2 Express-C on Ubuntu 7.04 'Feisty Fawn'</H1
|
|
><P
|
|
>These installation notes are based on a single-partition installation
|
|
using the 2.6.20-16-generic kernel.</P
|
|
><P
|
|
>Note that IBM does not yet 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
|
|
>Also be aware that the PowerPC architecture is no longer supported in
|
|
Ubuntu 7.04 and later.</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN770"
|
|
></A
|
|
>16.1. Installation notes</H2
|
|
><P
|
|
>Since you cannot log in as root directly with an Ubuntu system, this
|
|
DB2 installation is run as the default user created during Ubuntu
|
|
setup (i.e. the regular user account with 'sudo' capability).</P
|
|
><P
|
|
>There are two ways of installing DB2 Express-C 9 on Ubuntu. The harder
|
|
of the two methods is to use the default DB2 <B
|
|
CLASS="command"
|
|
>db2setup</B
|
|
>,
|
|
and then make adjustments to the Ubuntu system afterwards to handle the
|
|
slight differences of Ubuntu's Debian-based packaging system. For
|
|
reasons of clarity and brevity, I will omit the instructions for doing it
|
|
this more difficult way; however, if you would like to see these
|
|
instructions, please send me an email (db2howto@gmail.com) and I will
|
|
pass them along.</P
|
|
><P
|
|
>The easy way to install DB2 Express-C on Ubuntu 7.04 is to download
|
|
the DB2 Express-C Debian package file and then use the Ubuntu package
|
|
installer. This way, almost everything is done for you, from installation to
|
|
configuration. Here's how to do it:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>Use any FTP client software and connect to:
|
|
<A
|
|
HREF=""
|
|
TARGET="_top"
|
|
>ftp.software.ibm.com/software/data/db2/express/latest_debs</A
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Download <TT
|
|
CLASS="filename"
|
|
>db2exc_9.1.2-1_i386.deb</TT
|
|
> (or the
|
|
latest equivalent .deb file)
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Once the download is complete, run this command:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>sudo gdebi-gtk db2exc_9.1.2-1_i386.deb</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Click "<B
|
|
CLASS="command"
|
|
>Install Package</B
|
|
>"</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Click "<B
|
|
CLASS="command"
|
|
>Close</B
|
|
>" once the package has been
|
|
installed</P
|
|
></LI
|
|
></OL
|
|
>
|
|
After hitting the "<B
|
|
CLASS="command"
|
|
>Install Package</B
|
|
>" button, the Ubuntu
|
|
package installer will unpack and install the package and configure the DB2
|
|
users and default instance. Click the "<B
|
|
CLASS="command"
|
|
>Close</B
|
|
>" button
|
|
once the installation is complete.
|
|
</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN794"
|
|
></A
|
|
>16.2. Post-installation notes</H2
|
|
><P
|
|
></P
|
|
><P
|
|
>After installation by Synaptic, there are a few steps required to get
|
|
DB2 up and running smoothly.
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>Usable passwords for the DB2 default accounts.</P
|
|
><P
|
|
>To actually log in or connect to the DB2 databases and servers
|
|
using the default DB2 users (db2inst1, db2fenc1, and dasusr1), you need
|
|
to modify the initial passwords. To do this, open a terminal (as the
|
|
regular user), and type <B
|
|
CLASS="command"
|
|
>sudo su -</B
|
|
> to get root access.
|
|
Then run these three commands:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>passwd db2inst1
|
|
passwd db2fenc1
|
|
passwd dasusr1</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
Each time you will be asked to set the new password for the specified
|
|
user account.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Change the default shell for the DB2 default accounts.</P
|
|
><P
|
|
>The default command shell for the DB2 accounts is set as just a
|
|
plain old <B
|
|
CLASS="command"
|
|
>/bin/sh</B
|
|
>. To get the handy features of the
|
|
BASH shell, you'll want to change it for these three accounts. In the
|
|
same root access command window, open the
|
|
<TT
|
|
CLASS="filename"
|
|
>/etc/passwd</TT
|
|
> file in your favorite text editor and
|
|
change:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
> db2inst1:x:1001:1001::/home/db2inst1:/bin/sh
|
|
db2fenc1:x:1002:1002::/home/db2fenc1:/bin/sh
|
|
dasusr1:x:1003:1003::/home/dasusr1:/bin/sh</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
to
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
> db2inst1:x:1001:1001::/home/db2inst1:/bin/bash
|
|
db2fenc1:x:1002:1002::/home/db2fenc1:/bin/bash
|
|
dasusr1:x:1003:1003::/home/dasusr1:/bin/bash</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Enable DB2 service ports for remote connections.</P
|
|
><P
|
|
>To enable outside users to get to your DB2 databases, you'll need
|
|
to set up the DB2 service port, as it is not configured by the Synaptic
|
|
installation process.</P
|
|
><P
|
|
>As the regular user, run <B
|
|
CLASS="command"
|
|
>sudo vi /etc/services</B
|
|
>
|
|
and add this line to the end of the file:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2c_db2inst1 50001/tcp # IBM DB2 instance - db2inst1</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
Then, as the DB2 instance owner (db2inst1 by default), run these commands:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2 update dbm cfg using SVCENAME db2c_db2inst1
|
|
db2set DB2COMM=tcpip
|
|
db2stop
|
|
db2start</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
Now remote users will be able to connect to the DB2 databases on your
|
|
Ubuntu system.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Enable remote DB2 administration connections.</P
|
|
><P
|
|
>To allow remote administration of your DB2 server, you'll need to
|
|
set up the DB2 DAS connection port, as it is not configured by the
|
|
Synaptic installation process.</P
|
|
><P
|
|
>As the regular user, run <B
|
|
CLASS="command"
|
|
>sudo vi /etc/services</B
|
|
>
|
|
and add this line to the end of the file:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>ibm-db2 523/tcp # IBM DB2 DAS
|
|
ibm-db2 523/udp # IBM DB2 DAS</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
Then, as the DB2 DAS owner (dasusr1 by default), run these commands:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2admin stop
|
|
db2admin start</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
Now remote administrators can connect to the DAS server to administer
|
|
databases on your Ubuntu system.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Correct instance restart problem</P
|
|
><P
|
|
>One issue of note with the Ubuntu 7.04 installation is that the
|
|
DB2 instances do not properly restart after a system reboot, and setting
|
|
DB2AUTOSTART=YES does not resolve the issue.</P
|
|
><P
|
|
>One workaround to this problem was suggested in part by
|
|
IgorM on the DB2 Express-C forum; and that is to create and execute your
|
|
own DB2 instance start up script.
|
|
</P
|
|
><P
|
|
>To begin with, login and create a new script file using the command:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>sudo vi /etc/init.d/db2</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
and then insert this text:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>#!/bin/sh
|
|
#
|
|
# Script to start DB2 instances on bootup.
|
|
#
|
|
set -e
|
|
|
|
. /lib/lsb/init-functions
|
|
|
|
case "$1" in
|
|
start)
|
|
/opt/ibm/db2exc/V9.1/instance/db2istrt
|
|
;;
|
|
stop|restart|reload)
|
|
;;
|
|
esac
|
|
|
|
exit 0</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
and write the file to disk with the <B
|
|
CLASS="command"
|
|
>:wq</B
|
|
> vi command.
|
|
</P
|
|
><P
|
|
> Note that the path to the executable is
|
|
<B
|
|
CLASS="command"
|
|
>/opt/ibm/db2exc/V9.1/</B
|
|
>, the default installation path
|
|
from the DB2 .deb file. If your installation put the DB2 files
|
|
elsewhere, be sure to adjust this script as required to find the
|
|
/instance/ directory.
|
|
</P
|
|
><P
|
|
>Once the script has been saved, give the file the proper ownership
|
|
and permissions:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>chown root.root db2
|
|
chmod 755 db2</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
></P
|
|
><P
|
|
>Now, to initialize this script so that it starts at boot time,
|
|
install the Boot-Up Manager with this command:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>sudo apt-get bum</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
><P
|
|
>After Synaptic downloads and installs the application file, you
|
|
can run the program by clicking <B
|
|
CLASS="command"
|
|
>System -> Administration ->
|
|
BootUp-Manager</B
|
|
>. Then click on the "Activate" checkbox beside
|
|
the <B
|
|
CLASS="command"
|
|
>db2</B
|
|
> entry. Click <B
|
|
CLASS="command"
|
|
>Apply</B
|
|
> and
|
|
say "No" to the dialog that asks if you want to start the service now.
|
|
Click <B
|
|
CLASS="command"
|
|
>Quit</B
|
|
>. The script will now run at your next boot and
|
|
start up all DB2 instances.
|
|
</P
|
|
><P
|
|
>The only other way to resolve the problem is to manually
|
|
start the instances after a reboot with <B
|
|
CLASS="command"
|
|
>db2start</B
|
|
> (as
|
|
the instance owner) and <B
|
|
CLASS="command"
|
|
>db2admin start</B
|
|
> (as the DAS
|
|
owner). Once DB2 Express-C has passed the validation process for Ubuntu
|
|
7.04, this instance start issue will disappear.
|
|
</P
|
|
></LI
|
|
></OL
|
|
>
|
|
</P
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><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"
|
|
><HR><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"
|
|
><HR><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="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="help"
|
|
></A
|
|
>18. Installing the DB2 Information Center</H1
|
|
><P
|
|
>The DB2 Information Center delivers the DB2 product documentation inside
|
|
an Eclipse-based help system, and provides a convenient way to search and utilize
|
|
the DB2 documentation.</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="infocenter"
|
|
></A
|
|
>18.1. Installing the Information Center locally</H2
|
|
><P
|
|
>To begin, mount the DB2 Information Center CD in your system drive, or
|
|
if you downloaded the compressed file through the Express-C website, expand
|
|
the tarball containing the installation utilities.</P
|
|
><P
|
|
>Change to the base directory (<TT
|
|
CLASS="filename"
|
|
>doce/disk1/</TT
|
|
>) and
|
|
run the <B
|
|
CLASS="command"
|
|
>db2setup</B
|
|
> utility. This will launch the DB2 setup
|
|
wizard. You can also use the other setup methods, but since the GUI
|
|
installation sets up and configures everything for you, it's the
|
|
method I recommend.</P
|
|
><P
|
|
>Installation Steps:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>Select the "Install a Product" option from the launcher, and
|
|
then click the "Install New" button in the main panel.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Read the description and click "Next".</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Read the license agreement, and if you agree, select
|
|
"Accept" and click "Next".</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>By default, the installation script will install the Information
|
|
Center locally and generate a response file. The choice is up to you,
|
|
but we're only doing a local install, so choose the "Install DB2
|
|
Information Center on this computer" option instead. Click
|
|
"Next".</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Add any additional languages that you want to have
|
|
installed. English is installed by default and cannot be
|
|
deselected. Each additional language will add anywhere from
|
|
5 MB to 50 MB to the installation size. Click "Next".</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>The next panel is where things get a little interesting. Here
|
|
you can specify the service name that the Information Center will
|
|
run under. An entry will be added to the
|
|
<TT
|
|
CLASS="filename"
|
|
>/etc/services</TT
|
|
> file for this service. You
|
|
probably don't need to change this, unless you have another service
|
|
running as "db2icv91". </P
|
|
><P
|
|
>Also, this panel is where you specify the system port that the
|
|
Information Center will use to serve up the documentation. By
|
|
default, this is port 51000.</P
|
|
><P
|
|
>These settings will change the configuration for
|
|
all DB2 products installed on the local system, so that their help
|
|
system will use the parameters you define here. Click "Next".</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Read the summary of what will be done, then click "Finish" to
|
|
start the file installation</P
|
|
></LI
|
|
></OL
|
|
>
|
|
</P
|
|
><DIV
|
|
CLASS="sect3"
|
|
><HR><H3
|
|
CLASS="sect3"
|
|
><A
|
|
NAME="AEN891"
|
|
></A
|
|
>18.1.1. Post-installation notes</H3
|
|
><P
|
|
>You can change which directory the Information Center uses as a
|
|
temporary working directory. To do this, modify the DB2_ECLIPSEIC_DATA
|
|
parameter in the db2ic.conf file
|
|
found in the <TT
|
|
CLASS="filename"
|
|
>/opt/ibm/db2ic/V9/cfg</TT
|
|
>
|
|
directory. The temporary directory can be
|
|
anywhere where the "bin" user can write to.</P
|
|
><P
|
|
>Also in this file, you can change the port used to serve up the
|
|
Information Center, in case you change your mind later on about the one
|
|
you set up during the install. Just change the DB2_ECLIPSEIC_PORT
|
|
parameter to the new number (though it must be a port under the maximum of
|
|
65535).</P
|
|
><P
|
|
>After making any changes, do a <TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>/etc/init.d/db2icdv9 restart</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
to have your changes picked up by the Information Center (see below for
|
|
more details on the db2icd daemon).</P
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN898"
|
|
></A
|
|
>18.2. The Information Center daemon</H2
|
|
><P
|
|
>The Information Center daemon is set up during installation and is
|
|
used to launch the background process that runs the Information Center. The
|
|
daemon script, named <B
|
|
CLASS="command"
|
|
>db2icdv9</B
|
|
> is installed to the <TT
|
|
CLASS="filename"
|
|
>/etc/init.d/</TT
|
|
> directory, and start up symbolic
|
|
links are added to the <TT
|
|
CLASS="filename"
|
|
>/etc/init.d/rc.X/</TT
|
|
> run-level folders. By
|
|
default, the daemon is turned on for run-levels 3 and 5. You can modify
|
|
these run-levels with any system init utility (<B
|
|
CLASS="command"
|
|
>chkconfig</B
|
|
>,
|
|
<B
|
|
CLASS="command"
|
|
>ntsysv</B
|
|
>, or any of the X-based variants).</P
|
|
><P
|
|
>There are 5 commands you can pass to the daemon:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>start — Starts the Information Center, using the
|
|
configuration parameters set in the /opt/ibm/db2ic/V9/cfg/db2ic.conf
|
|
file.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>stop — Halts a running Information Center.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>restart — A combination command that stops, then
|
|
starts the daemon again.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>reload — Same as restart.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>status — Provides information on whether the Information
|
|
Center is running, and if it is running, what the process IDs (PID)
|
|
are.</P
|
|
></LI
|
|
></OL
|
|
>
|
|
</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN918"
|
|
></A
|
|
>18.3. Accessing an installed Information Center</H2
|
|
><P
|
|
>There are three possible methods to access the DB2
|
|
Information Center:
|
|
<P
|
|
></P
|
|
><UL
|
|
><LI
|
|
><P
|
|
>Via the publib.boulder.ibm.com Web site (this is
|
|
the default option enabled during a DB2 installation)</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Via an intranet machine that is hosting the DB2
|
|
Information Center within your own organization</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Via an Information Center that is installed and set up on your
|
|
local machine</P
|
|
></LI
|
|
></UL
|
|
>
|
|
You can configure which access method will be used, either during the DB2
|
|
installation (only by specifying a "Custom" installation), or afterwards
|
|
in the tools configuration panel (in the GUI tools), or from the command
|
|
line.</P
|
|
><P
|
|
>To make the change using the GUI tools (Control Center), open the
|
|
<B
|
|
CLASS="command"
|
|
>Tools</B
|
|
> menu, select <B
|
|
CLASS="command"
|
|
>Tools Settings</B
|
|
>,
|
|
and then the <B
|
|
CLASS="command"
|
|
>Documentation</B
|
|
> tab. On this panel, you can specify a host URL
|
|
and port where an Information Center can be found. When putting a hostname
|
|
in, do not add the "http://" prefix, or any
|
|
subdirectories – just type in the hostname, and the internal code
|
|
will do the rest.</P
|
|
><P
|
|
>To change the access points from the command line, execute these
|
|
commands:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2set DB2_DOCHOST=<TT
|
|
CLASS="varname"
|
|
>host_URL</TT
|
|
>
|
|
db2set DB2_DOCPORT=<TT
|
|
CLASS="varname"
|
|
>host_port</TT
|
|
></PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
where <TT
|
|
CLASS="varname"
|
|
>host_URL</TT
|
|
> is the location hostname of the Information Center. This
|
|
could be: mydocserver.myorg.net or localhost (for a local installation),
|
|
and <TT
|
|
CLASS="varname"
|
|
>host_port</TT
|
|
> is the port number where the Information Center was
|
|
installed.</P
|
|
><P
|
|
>By default, these DB2 environment settings are blank, which means
|
|
that DB2 defaults to the
|
|
http://publib.boulder.ibm.com/infocenter/db2help/ Web site.</P
|
|
><P
|
|
>To invoke the DB2 Information Center from the GUI tools, click on
|
|
the "?" icon in the toolbar, any of the "Help" hyperlinks or buttons, or
|
|
by selecting any of the menu items in the "Help" menu.</P
|
|
><P
|
|
>To invoke the DB2 Information Center from the command line, issue
|
|
any of these commands:
|
|
<P
|
|
></P
|
|
><UL
|
|
><LI
|
|
>db2icdocs</LI
|
|
><LI
|
|
>db2help</LI
|
|
><LI
|
|
>db2ic</LI
|
|
><LI
|
|
>db2cc -ic</LI
|
|
></UL
|
|
>
|
|
</P
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="uninstalling"
|
|
></A
|
|
>19. Removing DB2 Express-C</H1
|
|
><P
|
|
>Uninstalling DB2 Express-C is a bit more detailed than the installation
|
|
process. Unfortunately, at this time, there is no GUI-based uninstaller
|
|
utility like there is for installation. Follow the steps below to completely
|
|
remove the DB2 Express-C software from your system. Since the database files
|
|
are kept in the home directory of the instance user, you can keep the database
|
|
files by skipping the removal of the instance owner (the last step).</P
|
|
><P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>Remove the Database Administration Server. Switch to the DAS owner
|
|
(dasusr1 by default), either through the <B
|
|
CLASS="command"
|
|
>su - dasusr1</B
|
|
>
|
|
command or by logging in to the system directly as the DAS user, and issue
|
|
the command <B
|
|
CLASS="command"
|
|
>db2admin stop</B
|
|
>. Then switch to the root
|
|
user, and issue the
|
|
<B
|
|
CLASS="command"
|
|
>/opt/ibm/db2/V9.1/instance/dasdrop</B
|
|
> command.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Remove the DB2 instance(s). Switch to the instance owner
|
|
(db2inst1 by default), either through the <B
|
|
CLASS="command"
|
|
>su - db2inst1</B
|
|
>
|
|
command or by logging in to the system directly as the instance user, and
|
|
issue the command <B
|
|
CLASS="command"
|
|
>db2stop</B
|
|
>. Then, as root, remove the
|
|
instance by issuing the <B
|
|
CLASS="command"
|
|
>/opt/ibm/db2/V9.1/instance/db2idrop
|
|
db2_instance</B
|
|
> command, where <TT
|
|
CLASS="varname"
|
|
>db2_instance</TT
|
|
>
|
|
refers to the actual instance name you want to drop (for example,
|
|
/opt/ibm/db2/V9.1/instance/db2idrop db2inst1). If you want to verify which
|
|
instances are present on your system, run the
|
|
<B
|
|
CLASS="command"
|
|
>/opt/ibm/db2/V9.1/instance/db2ilist</B
|
|
> command.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Remove the software installation. As root, run the
|
|
<B
|
|
CLASS="command"
|
|
>/opt/ibm/db2/V9.1/install/db2_deinstall -a</B
|
|
> command. This will
|
|
remove the installation of DB2 from your system.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>If no longer need the DB2 database files (which are kept in the home
|
|
directory of the instance owner), you can remove the users that were
|
|
created during the installation of DB2 Express-C by entering these commands
|
|
as root:<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>userdel -r db2inst1
|
|
userdel -r dasusr1
|
|
userdel -r db2fenc1</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>(If you created different user names during
|
|
installation, substitute as necessary.)</P
|
|
></LI
|
|
></OL
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="using"
|
|
></A
|
|
>20. Using DB2</H1
|
|
><P
|
|
>This section gives you the basic information you need to start working
|
|
with DB2 Express-C on Linux. It includes instructions on issuing DB2 commands and SQL
|
|
statements from the command line, as well as the commands you need to start
|
|
the DB2 Control Center and the DB2 Information Center. For more information
|
|
about general DB2 usage, please investigate the DB2 manuals and Information
|
|
Center.</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN971"
|
|
></A
|
|
>20.1. DB2 Control Center</H2
|
|
><P
|
|
>To start the DB2 Control Center:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
> Ensure you are logged on to your Linux workstation using either
|
|
the DB2 Administration Server user ID (dasusr1 by default) or the DB2
|
|
instance user ID (db2inst1 by default). If you use the
|
|
<B
|
|
CLASS="command"
|
|
>su</B
|
|
> command to change to one of those users, ensure
|
|
you include the -l parameter to initialize the proper user
|
|
environment.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
> Start the X server, if it is not already started.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
> Start a terminal session, or type <B
|
|
CLASS="command"
|
|
>Alt + F2</B
|
|
> to bring
|
|
up the Linux "<B
|
|
CLASS="command"
|
|
>Run Command</B
|
|
>" dialog.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
> Type <B
|
|
CLASS="command"
|
|
>db2cc</B
|
|
> to start the DB2 Control Center.
|
|
</P
|
|
></LI
|
|
></OL
|
|
>
|
|
</P
|
|
><P
|
|
>The left side of the DB2 Control Center provides an
|
|
object based view of the database objects that you have catalogued,
|
|
including DB2 instances and databases on other DB2 servers.
|
|
</P
|
|
><P
|
|
>One way to add, edit, or drop database objects is to right-click on
|
|
the object to bring up a context menu.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN989"
|
|
></A
|
|
>20.2. DB2 Information Center</H2
|
|
><P
|
|
>As mentioned above, the new DB2 Information Center is a revamped
|
|
documentation display system that now encapsulates the task, concept and
|
|
reference information required to properly run DB2 . It can be installed
|
|
locally, on an intranet server, or accessed directly from the ibm.com
|
|
hosting service.</P
|
|
><P
|
|
>To start the DB2 Information Center:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>Ensure you are logged on to your Linux workstation using either
|
|
the DB2 Administration Server user ID (dasusr1 by default) or the DB2
|
|
instance user ID (db2inst1 by default). If you use the
|
|
<B
|
|
CLASS="command"
|
|
>su</B
|
|
> command to change to one of those users, ensure
|
|
you include the -l parameter to initialize the proper user
|
|
environment.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Ensure that the X server is started, as the Information
|
|
Center requires a Web browser.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Issue one of the launch commands:
|
|
<P
|
|
></P
|
|
><UL
|
|
><LI
|
|
>db2icdocs</LI
|
|
><LI
|
|
>db2help</LI
|
|
><LI
|
|
>db2ic</LI
|
|
><LI
|
|
>db2cc -ic</LI
|
|
></UL
|
|
>
|
|
</P
|
|
></LI
|
|
></OL
|
|
>
|
|
Alternatively, you can launch the Information Center from within the
|
|
Control Center (or any of the other GUI tools), by clicking an item under
|
|
the "Help" menu, or by clicking on the "?" (question mark) icon.</P
|
|
><P
|
|
>If you did not install the DB2 Information Center, or have not
|
|
configured your tools to use a different server, then these commands will launch
|
|
a detected browser, and take you directly to the IBM hosted DB2 Information
|
|
Center at <A
|
|
HREF="http://publib.boulder.ibm.com/infocenter/db2help/"
|
|
TARGET="_top"
|
|
>http://publib.boulder.ibm.com/infocenter/db2help/</A
|
|
>.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1008"
|
|
></A
|
|
>20.3. DB2 command line processor (CLP)</H2
|
|
><P
|
|
>If you are logged on to your Linux workstation using either the
|
|
DB2 Administration Server user ID or the DB2 instance user ID, you can
|
|
issue DB2 commands and SQL statements from the command line.</P
|
|
><P
|
|
>If this is your first time using DB2 , I would suggest creating
|
|
the DB2 sample database. The sample database is used
|
|
throughout the DB2 documentation and is required by most of the sample
|
|
applications.</P
|
|
><P
|
|
>To create the sample database, you can either select the <B
|
|
CLASS="command"
|
|
>Create
|
|
the SAMPLE database</B
|
|
> option from the DB2 First Steps launchpad, or by
|
|
issuing the <B
|
|
CLASS="command"
|
|
>db2sampl</B
|
|
> command from the command line.</P
|
|
><P
|
|
>Before you can issue an SQL statement, you have to connect to a
|
|
database. To connect to a database, enter the command:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2 CONNECT TO database USER userID USING password</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
><P
|
|
>To connect to a database, and have DB2 prompt you for the password,
|
|
issue the command:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2 CONNECT TO database USER userID</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
><P
|
|
>To connect to a database using the default user ID, issue the
|
|
command:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2 CONNECT TO database</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
><P
|
|
>Once you have connected to a database, you can then issue SQL
|
|
statements or DB2 commands against that database. For example, to select
|
|
all of the rows from the EMPLOYEE table in the SAMPLE database, issue
|
|
this command:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2 "SELECT * FROM employee"</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
><P
|
|
>You can avoid typing db2 as the prefix for every SQL statement and
|
|
DB2 command by issuing DB2 commands using the Command Line Processor
|
|
(CLP). To start the CLP, issue the <B
|
|
CLASS="command"
|
|
>db2</B
|
|
> command by itself
|
|
from a Linux command line terminal. DB2 provides the following prompt:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>You can issue database manager commands and SQL statements
|
|
from the command prompt. For example:
|
|
db2 => connect to sample
|
|
db2 => bind sample.bnd
|
|
|
|
For general help, type: ?.
|
|
For command help, type: ? command, where command can be
|
|
the first few keywords of a database manager command. For example:
|
|
? CATALOG DATABASE for help on the CATALOG DATABASE command
|
|
? CATALOG for help on all of the CATALOG commands.
|
|
|
|
To exit db2 interactive mode, type QUIT at the command prompt. Outside
|
|
interactive mode, all commands must be prefixed with 'db2'.
|
|
To list the current command option settings, type LIST COMMAND OPTIONS.
|
|
|
|
For more detailed help, refer to the Online Reference Manual.
|
|
|
|
db2 =></PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
><P
|
|
>Some users prefer to avoid the CLP because it prevents using the
|
|
command line history features of the shell.</P
|
|
><P
|
|
>Some users claim that running the CLP within an Emacs shell gives
|
|
them the best of both worlds: they get command line history, and they
|
|
don't have to escape commands that contain lots of quotation marks and
|
|
brackets, but your mileage may vary.</P
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="tests"
|
|
></A
|
|
>21. Installation and operation test plan</H1
|
|
><P
|
|
></P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1031"
|
|
></A
|
|
>21.1. DB2 Express-C installation tests</H2
|
|
><P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>Log on as root (or gain root access through a terminal if a root
|
|
logon is not available)</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Mount the DVD (if installing from Discovery DVD set), or
|
|
download the appropriate Linux compressed image (tar.gz file) from the DB2
|
|
Express-C download site</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Copy the compressed image file to the <TT
|
|
CLASS="filename"
|
|
>/tmp</TT
|
|
>
|
|
directory</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Extract the files from the compressed image, either using the
|
|
Ark GUI tool or using the console command <B
|
|
CLASS="command"
|
|
>tar zxvf
|
|
db2exc_91_LNX_x86.tar.gz</B
|
|
></P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Inside the <TT
|
|
CLASS="filename"
|
|
>/tmp </TT
|
|
> folder, change to the
|
|
<TT
|
|
CLASS="filename"
|
|
>exp/disk1i </TT
|
|
> directory and run the
|
|
<B
|
|
CLASS="command"
|
|
>db2setup</B
|
|
> command:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>./db2setup</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>In the DB2 setup Launchpad, choose <B
|
|
CLASS="command"
|
|
>Install a Product</B
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Choose <B
|
|
CLASS="command"
|
|
>Install New</B
|
|
></P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Click "<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>"</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Verify the license and change the radio button to
|
|
<B
|
|
CLASS="command"
|
|
>Accept</B
|
|
>, then choose
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>" to continue the installation</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Choose a <B
|
|
CLASS="command"
|
|
>Typical</B
|
|
> installation and click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>"</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Verify the install path, or change it to some point on your
|
|
system with at least 470 MB free, click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>"</P
|
|
></LI
|
|
><LI
|
|
>Set up the DAS (DB2 Administration Server) owner account. You
|
|
can use an existing user, or set up a new one (the default user is
|
|
'dasusr1'). Click "<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>"</LI
|
|
><LI
|
|
><P
|
|
>Create a DB2 instance. Click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>"</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Set up the DB2 instance owner account. Again, you can use an
|
|
existing user, or set up a new one (the default instance owner is
|
|
'db2inst1'). Click "<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>"
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Set up the DB2 fenced user account. Same as before, use an
|
|
existing user or set up a new one. Click
|
|
"<B
|
|
CLASS="command"
|
|
>Next</B
|
|
>"</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Click "<B
|
|
CLASS="command"
|
|
>Finish</B
|
|
>" to initiate the install</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>If there are any problems with the installation, it will show up
|
|
in the installation log (the log is also kept in the
|
|
<TT
|
|
CLASS="filename"
|
|
>/tmp</TT
|
|
> directory as <TT
|
|
CLASS="filename"
|
|
>db2setup.log</TT
|
|
>
|
|
and <TT
|
|
CLASS="filename"
|
|
>db2setup.err</TT
|
|
>)</P
|
|
></LI
|
|
></OL
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1089"
|
|
></A
|
|
>21.2. DB2 Express-C operation tests</H2
|
|
><P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>Log in as the DB2 instance owner (db2inst1 by default)</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Open a terminal and run 'db2sampl' to create the SAMPLE database</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test terminal based commands:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="a"
|
|
><LI
|
|
>db2 connect to sample</LI
|
|
><LI
|
|
>db2 'select * from dept'</LI
|
|
></OL
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test DB2 Control Center:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="a"
|
|
><LI
|
|
>Open the control center with 'db2cc' command</LI
|
|
><LI
|
|
>Select the "Advanced" view</LI
|
|
><LI
|
|
>Verify the SAMPLE database is present under the "All databases" tab</LI
|
|
><LI
|
|
>Look at the contents of one of the SAMPLE database tables and
|
|
views (e.g. vphone)</LI
|
|
></OL
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Create TOOLS database:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2 'create tools catalog TOOLS create new database TOOLSDB'</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Launch DB2 Task Center:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="a"
|
|
><LI
|
|
>Create a task that issues a simple query like "connect to sample; select tabname from syscat.tables; connect reset;", schedule to run now</LI
|
|
><LI
|
|
>Click on "show results", no errors should exist</LI
|
|
></OL
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Launch DB2 Journal: You should be able to see the results of the
|
|
task you ran in the task center from the Journal.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test DB2 Configuration Assistant
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="a"
|
|
><LI
|
|
><P
|
|
>Start Configuration Assistant from the Control Center, or with <B
|
|
CLASS="command"
|
|
>db2ca</B
|
|
></P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>You should see the SAMPLE database listed, if not, click View, then Refresh.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Right click on the SAMPLE database, choose Change Database,
|
|
then in step 4 of the wizard, register the database as a CLI/ODBC
|
|
source, and catalog as system data source. Click Finish to commit the
|
|
changes</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Right click on the SAMPLE database again, and click on Test
|
|
Connection. Select all types (Standard (ODBC), CLI, JDBC), then type in
|
|
a userid and password, and click on Test Connection. Ensure all tests
|
|
are successful.</P
|
|
></LI
|
|
></OL
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test DB2 trace facility: <B
|
|
CLASS="command"
|
|
>db2trc on</B
|
|
> -- check
|
|
for positive response, then run <B
|
|
CLASS="command"
|
|
>db2trc off</B
|
|
></P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test DB2 problem determination facility: <B
|
|
CLASS="command"
|
|
>db2pd -db
|
|
sample > sample.txt</B
|
|
> (examine output for errors)</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test DB2 license: <B
|
|
CLASS="command"
|
|
>db2licm -l</B
|
|
> should return:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
> Product name: "DB2 Express Edition"
|
|
License type: "Unwarranted"
|
|
Expiry date: "Permanent"
|
|
Product identifier: "db2exp"
|
|
Version information: "9.1"
|
|
Max number of CPUs: "2"
|
|
</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test <B
|
|
CLASS="command"
|
|
>db2dart</B
|
|
>:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2 force applications all
|
|
db2dart sample</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
(should report that DB2DART processing has completed successfully)
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test db2look facility: <B
|
|
CLASS="command"
|
|
>db2look -d sample -e >
|
|
sample.ddl</B
|
|
> (should complete successfully)</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Test remote connections:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="a"
|
|
><LI
|
|
><P
|
|
>Create connection through command prompt on DB2 remote
|
|
client system:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2 catalog tcpip node test remote computername server 50001
|
|
db2 catalog db sample at node test</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>From remote machine:
|
|
<TABLE
|
|
BORDER="0"
|
|
BGCOLOR="#E0E0E0"
|
|
WIDTH="100%"
|
|
><TR
|
|
><TD
|
|
><FONT
|
|
COLOR="#000000"
|
|
><PRE
|
|
CLASS="screen"
|
|
>db2 connect to sample
|
|
db2 "select * from dept"</PRE
|
|
></FONT
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
>
|
|
</P
|
|
></LI
|
|
></OL
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Reboot server and retest via remote connection (to verify DB2
|
|
instance autostart and that any firewall changes stick)
|
|
</P
|
|
></LI
|
|
></OL
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="resources"
|
|
></A
|
|
>22. Resources</H1
|
|
><P
|
|
>This section lists available additional resources for information on
|
|
using DB2 Express-C 9 for Linux:</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1162"
|
|
></A
|
|
>22.1. Forums and Newsgroups</H2
|
|
><P
|
|
></P
|
|
><UL
|
|
><LI
|
|
><P
|
|
>IBM developerWorks forums</P
|
|
><P
|
|
><A
|
|
HREF="http://www.ibm.com/developerworks/forums/db2_forums.jsp"
|
|
TARGET="_top"
|
|
>http://www.ibm.com/developerworks/forums/db2_forums.jsp</A
|
|
></P
|
|
><P
|
|
>This page lists the available developerWorks hosted web forums.
|
|
Many of them are mirrors of the regular Usenet DB2 newsgroups.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>DB2 Express-C developerWorks forum</P
|
|
><P
|
|
><A
|
|
HREF="http://www.ibm.com/developerworks/forums/dw_forum.jsp?forum=805&cat=81"
|
|
TARGET="_top"
|
|
>http://www.ibm.com/developerworks/forums/dw_forum.jsp?forum=805&cat=81</A
|
|
></P
|
|
><P
|
|
>The main site for DB2 Express-C support questions. All support
|
|
functionality for unwarranted versions of Express-C comes from this
|
|
community support forum. Lots of IBM developers (including the DB2
|
|
Express-C team) regularly monitor and participate in this forum.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>DB2 9 developerWorks forum</P
|
|
><P
|
|
><A
|
|
HREF="http://www.ibm.com/developerworks/forums/dw_forum.jsp?forum=842&cat=81"
|
|
TARGET="_top"
|
|
>http://www.ibm.com/developerworks/forums/dw_forum.jsp?forum=842&cat=81</A
|
|
></P
|
|
><P
|
|
>The forum for general DB2 9 questions. Lots of DB2 developers
|
|
regularly monitor and participate in this forum.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>comp.databases.ibm-db2</P
|
|
><P
|
|
>Covers the use of DB2 on all platforms, including Linux
|
|
and UNIX, Windows, z/OS, iSeries, and pSeries. This forum is
|
|
quite active.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>ibm.software.db2.udb</P
|
|
><P
|
|
>Similar to comp.databases.ibm-db2, but handles questions
|
|
specific to the DB2 Universal Database product only.</P
|
|
></LI
|
|
></UL
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1186"
|
|
></A
|
|
>22.2. Web sites</H2
|
|
><P
|
|
></P
|
|
><UL
|
|
><LI
|
|
><P
|
|
>DB2 Universal Database for Linux</P
|
|
><P
|
|
><A
|
|
HREF="http://www.ibm.com/software/data/db2/linux/"
|
|
TARGET="_top"
|
|
>http://www.ibm.com/software/data/db2/linux</A
|
|
></P
|
|
><P
|
|
>The home portal for DB2 information on Linux.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>DB2 Express-C</P
|
|
><P
|
|
><A
|
|
HREF="http://www.ibm.com/software/data/db2/express/"
|
|
TARGET="_top"
|
|
>http://www.ibm.com/software/data/db2/express</A
|
|
></P
|
|
><P
|
|
>Main web portal for the DB2 Express-C product, including downloads
|
|
of the DB2 Express-C software and related utilities.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>DB2 Information Center</P
|
|
><P
|
|
><A
|
|
HREF="http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp"
|
|
TARGET="_top"
|
|
> http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp</A
|
|
>
|
|
</P
|
|
><P
|
|
>The DB2 Information Center is the most current source of official
|
|
DB2 documentation in 29 different languages. Set your browser language
|
|
preference and the site will return the translated version of a given
|
|
page if it is available, falling back to English content if not. Access
|
|
to the information is offered via search, navigation tree, or a
|
|
comprehensive <A
|
|
HREF="http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.doc/doc/r0024231.htm"
|
|
TARGET="_top"
|
|
> master index</A
|
|
>.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>DB2 Linux validation site</P
|
|
><P
|
|
><A
|
|
HREF="http://www.ibm.com/software/data/db2/linux/validate/"
|
|
TARGET="_top"
|
|
> http://www.ibm.com/software/data/db2/linux/validate/</A
|
|
></P
|
|
><P
|
|
>Information regarding IBM recommended and validated Linux
|
|
distributions for the current version of DB2.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>DB2 Online Support</P
|
|
><P
|
|
><A
|
|
HREF="http://www.ibm.com/software/data/db2/udb/support.html"
|
|
TARGET="_top"
|
|
>http://www.ibm.com/software/data/db2/udb/support.html</A
|
|
></P
|
|
><P
|
|
>The official support channel for DB2 for Linux, UNIX and Windows.
|
|
Contains information and downloads regarding Fixpaks, APARs, Technotes,
|
|
DB2 Flashes, and more.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>DB2 PDF Manuals</P
|
|
><P
|
|
><A
|
|
HREF="http://www-1.ibm.com/support/docview.wss?rs=71&uid=swg27009552"
|
|
TARGET="_top"
|
|
>http://www-1.ibm.com/support/docview.wss?rs=71&uid=swg27009553</A
|
|
></P
|
|
><P
|
|
>If you like your information in discrete chunks, this is the place
|
|
to get official DB2 manuals in PDF format.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>DB2 for Linux white papers</P
|
|
><P
|
|
><A
|
|
HREF="http://www.ibm.com/software/data/db2/linux/papers.html"
|
|
TARGET="_top"
|
|
>http://www.ibm.com/software/data/db2/linux/papers.html</A
|
|
></P
|
|
><P
|
|
>White papers typically provide overviews or introductions
|
|
to new technology or new releases of a product.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>DB2 Magazine</P
|
|
><P
|
|
><A
|
|
HREF="http://www.db2mag.com"
|
|
TARGET="_top"
|
|
>http://www.db2mag.com</A
|
|
></P
|
|
><P
|
|
>This Web site is the online version of DB2 Magazine, which
|
|
publishes articles about using DB2 on Linux and other platforms.
|
|
You can also sign up for a free subscription to the print
|
|
version of the magazine.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>IBM developerWorks for DB2</P
|
|
><P
|
|
><A
|
|
HREF="http://www.ibm.com/developerworks/db2/"
|
|
TARGET="_top"
|
|
>http://www.ibm.com/developerworks/db2/</A
|
|
>
|
|
</P
|
|
><P
|
|
>A great resource for tutorials, learning resources, help,
|
|
and tips for improving DB2 and developing DB2-based
|
|
applications.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>International DB2 Users Group (IDUG)</P
|
|
><P
|
|
><A
|
|
HREF="http://www.idug.org/wps/portal/idug"
|
|
TARGET="_top"
|
|
>http://www.idug.org</A
|
|
></P
|
|
><P
|
|
>IDUG holds a number of international conferences on DB2
|
|
and has regional user groups. While IDUG has traditionally
|
|
focused on DB2 for z/OS and iSeries, they have increasingly
|
|
included information on DB2 for Linux, UNIX, and Windows. The
|
|
IDUG Web site includes online discussion forums and links to
|
|
other DB2 resources.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Red Hat Linux</P
|
|
><P
|
|
><A
|
|
HREF="http://www.redhat.com"
|
|
TARGET="_top"
|
|
>http://www.redhat.com</A
|
|
></P
|
|
><P
|
|
>Home to the Red Hat Linux distribution.</P
|
|
><P
|
|
>Also see <A
|
|
HREF="http://www.redhat.com/rhn/"
|
|
TARGET="_top"
|
|
>http://www.redhat.com/rhn/</A
|
|
>(the
|
|
Red Hat Network) for more information on system updates and
|
|
kernel information.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>SUSE Linux</P
|
|
><P
|
|
><A
|
|
HREF="http://www.novell.com/linux/"
|
|
TARGET="_top"
|
|
>http://www.novell.com/linux/</A
|
|
></P
|
|
><P
|
|
>Now a Novell business, this site is the home for the SUSE
|
|
Linux distribution.</P
|
|
><P
|
|
>Also see <A
|
|
HREF="http://support.novell.com/patches.html"
|
|
TARGET="_top"
|
|
>http://support.novell.com/patches.html</A
|
|
>
|
|
for more information on system updates and kernel
|
|
information.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Ubuntu Linux</P
|
|
><P
|
|
><A
|
|
HREF="http://www.ubuntu.com/"
|
|
TARGET="_top"
|
|
>http://www.ubuntu.com/</A
|
|
></P
|
|
><P
|
|
>Home to the Ubuntu Linux distribution. </P
|
|
><P
|
|
>Ubuntu is a community developed, Linux-based operating system that
|
|
is rapidly emerging as a favorite distributions, particularly amongst
|
|
new users.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Fedora Project</P
|
|
><P
|
|
><A
|
|
HREF="http://fedoraproject.org/"
|
|
TARGET="_top"
|
|
>http://fedoraproject.org/</A
|
|
></P
|
|
><P
|
|
>Home to the Fedora Project Linux distribution. </P
|
|
><P
|
|
>The Fedora Project is a collection of projects sponsored by Red
|
|
Hat and developed as a partnership between the open source community and
|
|
Red Hat engineers.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Mandriva Linux</P
|
|
><P
|
|
><A
|
|
HREF="http://www.mandriva.com/"
|
|
TARGET="_top"
|
|
>http://www.mandriva.com/</A
|
|
></P
|
|
><P
|
|
>Home to the Mandriva Linux distribution. </P
|
|
><P
|
|
>Mandriva's key product is the Mandriva Linux distribution. It is
|
|
available in individual user and enterprise versions. The company also
|
|
provides and maintains a completely free version called Free
|
|
Mandriva.</P
|
|
></LI
|
|
></UL
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="gfdl"
|
|
></A
|
|
>23. GNU Free Documentation License</H1
|
|
><P
|
|
>Copyright (C) 2000,2001,2002 Free Software Foundation, Inc.</P
|
|
><P
|
|
>59 Temple Place, Suite 330, Boston, MA 02111-1307 USA</P
|
|
><P
|
|
>Everyone is permitted to copy and distribute verbatim copies of
|
|
this license document, but changing it is not allowed.</P
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1278"
|
|
></A
|
|
>23.1. PREAMBLE</H2
|
|
><P
|
|
>The purpose of this License is to make a manual, textbook, or
|
|
other functional and useful document "free" in the sense of freedom: to
|
|
assure everyone the effective freedom to copy and redistribute it, with
|
|
or without modifying it, either commercially or noncommercially.
|
|
Secondarily, this License preserves for the author and publisher a way
|
|
to get credit for their work, while not being considered responsible for
|
|
modifications made by others.</P
|
|
><P
|
|
>This License is a kind of "copyleft", which means that derivative
|
|
works of the document must themselves be free in the same sense. It
|
|
complements the GNU General Public License, which is a copyleft license
|
|
designed for free software.</P
|
|
><P
|
|
>We have designed this License in order to use it for manuals for
|
|
free software, because free software needs free documentation: a free
|
|
program should come with manuals providing the same freedoms that the
|
|
software does. But this License is not limited to software manuals; it
|
|
can be used for any textual work, regardless of subject matter or
|
|
whether it is published as a printed book. We recommend this License
|
|
principally for works whose purpose is instruction or
|
|
reference.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1283"
|
|
></A
|
|
>23.2. APPLICABILITY AND DEFINITIONS</H2
|
|
><P
|
|
>This License applies to any manual or other work, in any
|
|
medium, that contains a notice placed by the copyright holder saying it
|
|
can be distributed under the terms of this License. Such a notice
|
|
grants a world-wide, royalty-free license, unlimited in duration, to use
|
|
that work under the conditions stated herein. The "Document", below,
|
|
refers to any such manual or work. Any member of the public is a
|
|
licensee, and is addressed as "you". You accept the license if you
|
|
copy, modify or distribute the work in a way requiring permission
|
|
under copyright law.</P
|
|
><P
|
|
>A "Modified Version" of the Document means any work containing the
|
|
Document or a portion of it, either copied verbatim, or with
|
|
modifications and/or translated into another language.</P
|
|
><P
|
|
>A "Secondary Section" is a named appendix or a front-matter
|
|
section of the Document that deals exclusively with the relationship of
|
|
the publishers or authors of the Document to the Document's overall
|
|
subject (or to related matters) and contains nothing that could fall
|
|
directly within that overall subject. (Thus, if the Document is in part
|
|
a textbook of mathematics, a Secondary Section may not explain any
|
|
mathematics.) The relationship could be a matter of historical
|
|
connection with the subject or with related matters, or of legal,
|
|
commercial, philosophical, ethical or political position regarding
|
|
them.</P
|
|
><P
|
|
>The "Invariant Sections" are certain Secondary Sections whose
|
|
titles are designated, as being those of Invariant Sections, in the
|
|
notice that says that the Document is released under this License. If a
|
|
section does not fit the above definition of Secondary then it is not
|
|
allowed to be designated as Invariant. The Document may contain zero
|
|
Invariant Sections. If the Document does not identify any Invariant
|
|
Sections then there are none.</P
|
|
><P
|
|
>The "Cover Texts" are certain short passages of text that are
|
|
listed, as Front-Cover Texts or Back-Cover Texts, in the notice that
|
|
says that the Document is released under this License. A Front-Cover
|
|
Text may be at most 5 words, and a Back-Cover Text may be at most 25
|
|
words.</P
|
|
><P
|
|
>A "Transparent" copy of the Document means a machine-readable
|
|
copy, represented in a format whose specification is available to the
|
|
general public, that is suitable for revising the document
|
|
straightforwardly with generic text editors or (for images composed of
|
|
pixels) generic paint programs or (for drawings) some widely available
|
|
drawing editor, and that is suitable for input to text formatters or for
|
|
automatic translation to a variety of formats suitable for input to text
|
|
formatters. A copy made in an otherwise Transparent file format whose
|
|
markup, or absence of markup, has been arranged to thwart or discourage
|
|
subsequent modification by readers is not Transparent. An image format
|
|
is not Transparent if used for any substantial amount of text. A copy
|
|
that is not "Transparent" is called "Opaque".</P
|
|
><P
|
|
>Examples of suitable formats for Transparent copies include plain
|
|
ASCII without markup, Texinfo input format, LaTeX input format, SGML or
|
|
XML using a publicly available DTD, and standard-conforming simple HTML,
|
|
PostScript or PDF designed for human modification. Examples of
|
|
transparent image formats include PNG, XCF and JPG. Opaque formats
|
|
include proprietary formats that can be read and edited only by
|
|
proprietary word processors, SGML or XML for which the DTD and/or
|
|
processing tools are not generally available, and the machine-generated
|
|
HTML, PostScript or PDF produced by some word processors for output
|
|
purposes only.</P
|
|
><P
|
|
>The "Title Page" means, for a printed book, the title page itself,
|
|
plus such following pages as are needed to hold, legibly, the material
|
|
this License requires to appear in the title page. For works in formats
|
|
which do not have any title page as such, "Title Page" means the text
|
|
near the most prominent appearance of the work's title, preceding the
|
|
beginning of the body of the text.</P
|
|
><P
|
|
>A section "Entitled XYZ"
|
|
means a named subunit of the Document whose title either is precisely
|
|
XYZ or contains XYZ in parentheses following text that translates XYZ in
|
|
another language. (Here XYZ stands for a specific section name mentioned
|
|
below, such as "Acknowledgements", "Dedications", "Endorsements", or
|
|
"History".) To "Preserve the Title" of such a section when you modify
|
|
the Document means that it remains a section "Entitled XYZ" according to
|
|
this definition.</P
|
|
><P
|
|
>The Document may include Warranty Disclaimers next to the notice
|
|
which states that this License applies to the Document. These Warranty
|
|
Disclaimers are considered to be included by reference in this License,
|
|
but only as regards disclaiming warranties: any other implication that
|
|
these Warranty Disclaimers may have is void and has no effect on the
|
|
meaning of this License.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1295"
|
|
></A
|
|
>23.3. VERBATIM COPYING</H2
|
|
><P
|
|
>You may copy and distribute the Document in any medium, either
|
|
commercially or noncommercially, provided that this License, the
|
|
copyright notices, and the license notice saying this License applies to
|
|
the Document are reproduced in all copies, and that you add no other
|
|
conditions whatsoever to those of this License. You may not use
|
|
technical measures to obstruct or control the reading or further copying
|
|
of the copies you make or distribute. However, you may accept
|
|
compensation in exchange for copies. If you distribute a large enough
|
|
number of copies you must also follow the conditions in section
|
|
3.</P
|
|
><P
|
|
>You may also lend copies, under the same conditions stated above,
|
|
and you may publicly display copies.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1299"
|
|
></A
|
|
>23.4. COPYING IN QUANTITY</H2
|
|
><P
|
|
>If you publish printed copies (or copies in media that commonly
|
|
have printed covers) of the Document, numbering more than 100, and the
|
|
Document's license notice requires Cover Texts, you must enclose the
|
|
copies in covers that carry, clearly and legibly, all these Cover Texts:
|
|
Front-Cover Texts on the front cover, and Back-Cover Texts on the back
|
|
cover. Both covers must also clearly and legibly identify you as the
|
|
publisher of these copies. The front cover must present the full title
|
|
with all words of the title equally prominent and visible. You may add
|
|
other material on the covers in addition. Copying with changes limited
|
|
to the covers, as long as they preserve the title of the Document and
|
|
satisfy these conditions, can be treated as verbatim copying in other
|
|
respects.</P
|
|
><P
|
|
>If the required texts for either cover are too voluminous to fit
|
|
legibly, you should put the first ones listed (as many as fit
|
|
reasonably) on the actual cover, and continue the rest onto adjacent
|
|
pages.</P
|
|
><P
|
|
>If you publish or distribute Opaque copies of the Document
|
|
numbering more than 100, you must either include a machine-readable
|
|
Transparent copy along with each Opaque copy, or state in or with each
|
|
Opaque copy a computer-network location from which the general
|
|
network-using public has access to download using public-standard
|
|
network protocols a complete Transparent copy of the Document, free of
|
|
added material. If you use the latter option, you must take reasonably
|
|
prudent steps, when you begin distribution of Opaque copies in quantity,
|
|
to ensure that this Transparent copy will remain thus accessible at the
|
|
stated location until at least one year after the last time you
|
|
distribute an Opaque copy (directly or through your agents or retailers)
|
|
of that edition to the public.</P
|
|
><P
|
|
>It is requested, but not required, that you contact the authors of
|
|
the Document well before redistributing any large number of copies, to
|
|
give them a chance to provide you with an updated version of the
|
|
Document.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1305"
|
|
></A
|
|
>23.5. MODIFICATIONS</H2
|
|
><P
|
|
>You may copy and distribute a Modified Version of the Document
|
|
under the conditions of sections 2 and 3 above, provided that you
|
|
release the Modified Version under precisely this License, with the
|
|
Modified Version filling the role of the Document, thus licensing
|
|
distribution and modification of the Modified Version to whoever
|
|
possesses a copy of it. In addition, you must do these things in the
|
|
Modified Version:
|
|
<P
|
|
></P
|
|
><OL
|
|
TYPE="1"
|
|
><LI
|
|
><P
|
|
>Use in the Title Page (and on the covers, if any) a title
|
|
distinct from that of the Document, and from those of previous
|
|
versions (which should, if there were any, be listed in the History
|
|
section of the Document). You may use the same title as a previous
|
|
version if the original publisher of that version gives
|
|
permission.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>List on the Title Page, as authors, one or more persons or
|
|
entities responsible for authorship of the modifications in the
|
|
Modified Version, together with at least five of the principal authors
|
|
of the Document (all of its principal authors, if it has fewer than
|
|
five), unless they release you from this requirement.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>State on the Title page the name of the publisher of the
|
|
Modified Version, as the publisher.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Preserve all the copyright notices of the Document.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Add an appropriate copyright notice for your modifications
|
|
adjacent to the other copyright notices.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Include, immediately after the copyright notices, a license
|
|
notice giving the public permission to use the Modified Version under
|
|
the terms of this License, in the form shown in the Addendum
|
|
below.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Preserve in that license notice the full lists of Invariant
|
|
Sections and required Cover Texts given in the Document's license
|
|
notice.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Include an unaltered copy of this License.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Preserve the section Entitled "History", Preserve its Title, and
|
|
add to it an item stating at least the title, year, new authors, and
|
|
publisher of the Modified Version as given on the Title Page. If there
|
|
is no section Entitled "History" in the Document, create one stating
|
|
the title, year, authors, and publisher of the Document as given on
|
|
its Title Page, then add an item describing the Modified Version as
|
|
stated in the previous sentence.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Preserve the network location, if any, given in the Document for
|
|
public access to a Transparent copy of the Document, and likewise the
|
|
network locations given in the Document for previous versions it was
|
|
based on. These may be placed in the "History" section. You may omit a
|
|
network location for a work that was published at least four years
|
|
before the Document itself, or if the original publisher of the
|
|
version it refers to gives permission.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>For any section Entitled "Acknowledgements" or "Dedications",
|
|
Preserve the Title of the section, and preserve in the section all the
|
|
substance and tone of each of the contributor acknowledgements and/or
|
|
dedications given therein.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Preserve all the Invariant Sections of the Document, unaltered
|
|
in their text and in their titles. Section numbers or the equivalent
|
|
are not considered part of the section titles.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Delete any section Entitled "Endorsements". Such a section may
|
|
not be included in the Modified Version.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Do not retitle any existing section to be Entitled
|
|
"Endorsements" or to conflict in title with any Invariant
|
|
Section.</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Preserve any Warranty Disclaimers.</P
|
|
></LI
|
|
></OL
|
|
>
|
|
</P
|
|
><P
|
|
>If the Modified Version includes new front-matter sections or
|
|
appendices that qualify as Secondary Sections and contain no material copied
|
|
from the Document, you may at your option designate some or all of these
|
|
sections as invariant. To do this, add their titles to the list of Invariant
|
|
Sections in the Modified Version's license notice. These titles must be
|
|
distinct from any other section titles.</P
|
|
><P
|
|
>You may add a section Entitled "Endorsements", provided it contains
|
|
nothing but endorsements of your Modified Version by various parties--for
|
|
example, statements of peer review or that the text has been approved by an
|
|
organization as the authoritative definition of a standard.</P
|
|
><P
|
|
>You may add a passage of up to five words as a Front-Cover Text, and a
|
|
passage of up to 25 words as a Back-Cover Text, to the end of the list of
|
|
Cover Texts in the Modified Version. Only one passage of Front-Cover Text
|
|
and one of Back-Cover Text may be added by (or through arrangements made by)
|
|
any one entity. If the Document already includes a cover text for the same
|
|
cover, previously added by you or by arrangement made by the same entity you
|
|
are acting on behalf of, you may not add another; but you may replace the
|
|
old one, on explicit permission from the previous publisher that added the
|
|
old one.</P
|
|
><P
|
|
>The author(s) and publisher(s) of the Document do not by this License
|
|
give permission to use their names for publicity for or to assert or imply
|
|
endorsement of any Modified Version.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1343"
|
|
></A
|
|
>23.6. COMBINING DOCUMENTS</H2
|
|
><P
|
|
>You may combine the Document with other documents released under this
|
|
License, under the terms defined in section 4 above for modified versions,
|
|
provided that you include in the combination all of the Invariant Sections
|
|
of all of the original documents, unmodified, and list them all as Invariant
|
|
Sections of your combined work in its license notice, and that you preserve
|
|
all their Warranty Disclaimers.</P
|
|
><P
|
|
>The combined work need only contain one copy of this License, and
|
|
multiple identical Invariant Sections may be replaced with a single copy. If
|
|
there are multiple Invariant Sections with the same name but different
|
|
contents, make the title of each such section unique by adding at the end of
|
|
it, in parentheses, the name of the original author or publisher of that
|
|
section if known, or else a unique number. Make the same adjustment to the
|
|
section titles in the list of Invariant Sections in the license notice of
|
|
the combined work.</P
|
|
><P
|
|
>In the combination, you must combine any sections Entitled "History"
|
|
in the various original documents, forming one section Entitled "History";
|
|
likewise combine any sections Entitled "Acknowledgements", and any sections
|
|
Entitled "Dedications". You must delete all sections Entitled
|
|
"Endorsements".</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1348"
|
|
></A
|
|
>23.7. COLLECTIONS OF DOCUMENTS</H2
|
|
><P
|
|
>You may make a collection consisting of the Document and other
|
|
documents released under this License, and replace the individual copies of
|
|
this License in the various documents with a single copy that is included in
|
|
the collection, provided that you follow the rules of this License for
|
|
verbatim copying of each of the documents in all other respects.</P
|
|
><P
|
|
>You may extract a single document from such a collection, and
|
|
distribute it individually under this License, provided you insert a copy of
|
|
this License into the extracted document, and follow this License in all
|
|
other respects regarding verbatim copying of that document.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1352"
|
|
></A
|
|
>23.8. AGGREGATION WITH INDEPENDENT WORKS</H2
|
|
><P
|
|
>A compilation of the Document or its derivatives with other separate
|
|
and independent documents or works, in or on a volume of a storage or
|
|
distribution medium, is called an "aggregate" if the copyright resulting
|
|
from the compilation is not used to limit the legal rights of the
|
|
compilation's users beyond what the individual works permit. When the
|
|
Document is included in an aggregate, this License does not apply to the
|
|
other works in the aggregate which are not themselves derivative works of
|
|
the Document.</P
|
|
><P
|
|
>If the Cover Text requirement of section 3 is applicable to these
|
|
copies of the Document, then if the Document is less than one half of the
|
|
entire aggregate, the Document's Cover Texts may be placed on covers that
|
|
bracket the Document within the aggregate, or the electronic equivalent of
|
|
covers if the Document is in electronic form. Otherwise they must appear on
|
|
printed covers that bracket the whole aggregate.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1356"
|
|
></A
|
|
>23.9. TRANSLATION</H2
|
|
><P
|
|
>Translation is considered a kind of modification, so you may
|
|
distribute translations of the Document under the terms of section 4.
|
|
Replacing Invariant Sections with translations requires special permission
|
|
from their copyright holders, but you may include translations of some or
|
|
all Invariant Sections in addition to the original versions of these
|
|
Invariant Sections. You may include a translation of this License, and all
|
|
the license notices in the Document, and any Warranty Disclaimers, provided
|
|
that you also include the original English version of this License and the
|
|
original versions of those notices and disclaimers. In case of a
|
|
disagreement between the translation and the original version of this
|
|
License or a notice or disclaimer, the original version will prevail.</P
|
|
><P
|
|
>If a section in the Document is Entitled "Acknowledgements",
|
|
"Dedications", or "History", the requirement (section 4) to Preserve its
|
|
Title (section 1) will typically require changing the actual title.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1360"
|
|
></A
|
|
>23.10. TERMINATION</H2
|
|
><P
|
|
>You may not copy, modify, sublicense, or distribute the Document
|
|
except as expressly provided for under this License. Any other attempt to
|
|
copy, modify, sublicense or distribute the Document is void, and will
|
|
automatically terminate your rights under this License. However, parties who
|
|
have received copies, or rights, from you under this License will not have
|
|
their licenses terminated so long as such parties remain in full
|
|
compliance.</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect2"
|
|
><HR><H2
|
|
CLASS="sect2"
|
|
><A
|
|
NAME="AEN1363"
|
|
></A
|
|
>23.11. FUTURE REVISIONS OF THIS LICENSE</H2
|
|
><P
|
|
>The Free Software Foundation may publish new, revised versions of the
|
|
GNU Free Documentation License from time to time. Such new versions will be
|
|
similar in spirit to the present version, but may differ in detail to
|
|
address new problems or concerns. See http://www.gnu.org/copyleft/.</P
|
|
><P
|
|
>Each version of the License is given a distinguishing version number.
|
|
If the Document specifies that a particular numbered version of this License
|
|
"or any laterversion" applies to it, you have the option of following the
|
|
terms and conditions either of that specified version or of any later
|
|
version that has been published (not as a draft) by the Free Software
|
|
Foundation. If the Document does not specify a version number of this
|
|
License, you may choose any version ever published (not as a draft) by the
|
|
Free Software Foundation.</P
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="sect1"
|
|
><HR><H1
|
|
CLASS="sect1"
|
|
><A
|
|
NAME="trademarks"
|
|
></A
|
|
>24. Trademarks</H1
|
|
><P
|
|
>DB2, IBM, pureXML, iSeries, pSeries, zSeries, and z/OS are trademarks or
|
|
registered trademarks of International Business Machines Corporation in the
|
|
United States, other countries, or both.</P
|
|
><P
|
|
>Java and all Java-based trademarks are trademarks of Sun Microsystems,
|
|
Inc. in the United States, other countries, or both.</P
|
|
><P
|
|
>Windows is a trademark of Microsoft Corporation in the United States,
|
|
other countries, or both.</P
|
|
><P
|
|
>Intel and Pentium are trademarks of Intel Corporation in the United
|
|
States, other countries, or both.</P
|
|
><P
|
|
>UNIX is a registered trademark of The Open Group in the United States
|
|
and other countries.</P
|
|
><P
|
|
>Linux is a trademark of Linus Torvalds in the United States, other
|
|
countries, or both.</P
|
|
><P
|
|
>Other company, product, or service names may be trademarks or
|
|
service marks of others.</P
|
|
></DIV
|
|
></DIV
|
|
></BODY
|
|
></HTML
|
|
> |