DB2 Version 7.1 for Linux HOWTO

Dan Scott

Revision History
Revision 1.2.4 2001-06-02 Revised by: dbs
Running JDK 1.1.8 on Red Hat 7.1
Revision 1.2.3 2001-04-25 Revised by: dbs
Red Hat 7.1 install instructions, more DB2 on Debian info, connecting to AS/400 databases, buffer pool memory limits, converted to DocBook XML.
Revision 1.2.1 2000-10-25 Revised by: dbs
Basic Red Hat 7.0 info, additional Debian instructions.
Revision 1.2 2000-09-25 Revised by: dbs
IBM JDK 1.3 works! More troubleshooting.
Revision 1.1 2000-07-28 Revised by: dbs
Documented _SHM_ID_BITS kernel parameter tuning for increasing number of available connections. Added basic indexing.
Revision 1.0 2000-07-06 Revised by: dbs
Added basic Debian instructions. Corrected some factual, stylistic, and grammatical mistakes. Licensed document under GNU GPL. Submitted document to LDP.
Revision 0.7 2000-04-26 Revised by: dbs
Based on DB2 V7.1 beta release, wrote install instructions for Caldera 2.4, Red Hat 6.2, SuSE 6.2, SuSE 6.3, and TurboLinux 6.0.

This HOWTO gives you explicit instructions on installing DB2 Universal Database Version 7.1 for Linux on the following Intel x86-based distributions: Caldera OpenLinux 2.4, Debian, Linux-Mandrake 7.2, Red Hat Linux 6.2, Red Hat Linux 7.1, SuSE Linux 6.2, 6.3, and 7.0, and TurboLinux 6.0. After installing DB2, you can work with a sample database, connect to your DB2 server from a remote machine, and administer DB2 using the DB2 Control Center.


Table of Contents
1. Introduction
1.1. Why a DB2 installation HOWTO?
1.2. Who should read this HOWTO?
1.3. New versions of this document
1.4. Copyright and License
1.5. Credits
1.6. About the author
2. Prerequisites
2.1. What are prerequisites?
3. Preparing your distribution for DB2
3.1. Caldera OpenLinux 2.4
3.1.1. Before installing DB2 on Caldera OpenLinux
3.1.2. Installing DB2 and creating instances on Caldera
3.1.3. After installing DB2 on Caldera
3.1.3.1. Adding instance user IDs to their groups
3.1.3.2. Changing the default home page in Netscape
3.1.3.3. Removing the Caldera login greeting
3.2. Linux-Mandrake 7.2
3.2.1. Before installing DB2 on Linux-Mandrake
3.2.2. Installing DB2 and creating instances on Linux-Mandrake
3.2.3. After installing DB2 on Linux-Mandrake
3.3. Red Hat Linux 6.2
3.3.1. Before installing DB2 on Red Hat
3.3.2. Installing DB2 and creating instances on Red Hat
3.3.3. After installing DB2 on Red Hat
3.4. Red Hat Linux 7.1
3.4.1. Before installing DB2 on Red Hat
3.4.2. Installing DB2 and creating instances on Red Hat
3.4.3. After installing DB2 on Red Hat
3.5. SuSE Linux
3.5.1. Before installing DB2 on SuSE
3.5.2. Installing DB2 and creating instances on SuSE
3.5.3. After installing DB2 on SuSE
3.6. TurboLinux 6.0
3.6.1. Before installing DB2 on TurboLinux
3.6.2. Installing DB2 on TurboLinux
3.6.3. After installing DB2 on TurboLinux
4. Installing DB2 using db2setup
4.1. Using the db2setup utility
4.2. Installing DB2 components
5. Installing DB2 on other Linux distributions
6. Creating DB2 instances
6.1. Overview of DB2 Administration Server
6.2. Overview of DB2 instance
7. Removing DB2
8. Using DB2
8.1. DB2 Control Center
8.2. DB2 Information Center
8.3. The DB2 command line
9. Troubleshooting
9.1. Problems with DB2 installation
9.2. Problems creating a DB2 instance
9.3. Problems using DB2
9.4. Problems starting the DB2 Control Center
10. Improving DB2 Version 7.1 performance on Linux
10.1. Increasing maximum connections
10.2. Creating and configuring buffer pools
11. Installing the IBM Developer Kit for Java
12. Using the 2.4 kernel with DB2 Version 7.1
A. Resources
B. GNU General Public License
B.1. Preamble
B.1.1. GNU GENERAL PUBLIC LICENSE TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION
B.1.2. How to Apply These Terms to Your New Programs