DB2 Version 7.1 for Linux HOWTO

Dan Scott

Revision History
Revision 1.2.72003-12-05Revised by: dbs
Add pointers to DB2 Version 8 information as a stop-gap measure until a real HOWTO is available.
Revision 1.2.62002-09-21Revised by: dbs
Add Mandrake 8.1, SuSE 7.3 install instructions from contributor Mykola Buryak.
Revision 1.2.52002-07-16Revised by: dbs
Fixed or removed some broken links, added a few new resources.
Revision 1.2.42001-06-02Revised by: dbs
Running JDK 1.1.8 on Red Hat 7.1
Revision 1.2.32001-04-25Revised 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.12000-10-25Revised by: dbs
Basic Red Hat 7.0 info, additional Debian instructions.
Revision 1.22000-09-25Revised by: dbs
IBM JDK 1.3 works! More troubleshooting.
Revision 1.12000-07-28Revised by: dbs
Documented _SHM_ID_BITS kernel parameter tuning for increasing number of available connections. Added basic indexing.
Revision 1.02000-07-06Revised by: dbs
Added basic Debian instructions. Corrected some factual, stylistic, and grammatical mistakes. Licensed document under GNU GPL. Submitted document to LDP.
Revision 0.72000-04-26Revised 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, Mandrake Linux 7.2 and 8.1, Red Hat Linux 6.2 and 7.1, SuSE Linux 6.2, 6.3, 7.0, and 7.3, 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.2. Mandrake Linux 7.2
3.3. Mandrake Linux 8.1
3.4. Red Hat Linux 6.2
3.5. Red Hat Linux 7.1
3.6. SuSE Linux
3.7. TurboLinux 6.0
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