9. Installing DB2 Express-C on Fedora 7

9.1. Installation notes

The only installation error encountered was found when launching the ./db2setup command. The screen displayed this error:

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 ...

To resolve this error, use the yum package utility to install the necessary C++ compatibility libraries:

yum -y install compat-libstdc++-33

Installation succeeded after installing the C++ libraries.

9.2. Post-installation notes

Basic test results (see Section 21 for more details) were successful.

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:

db2set DB2AUTOSTART=YES

This will ensure that the DB2 instance is initialized and ready to receive incoming connections after a reboot (intentional or otherwise).

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 /etc/sysconfig/iptables file. If you have enabled your firewall (using the iptables 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 iptablesfile (anywhere amongst the -j ACCEPT rules):

-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

These rules were added directly to the iptables 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.

You can use db2 get dbm cfg | grep SVCENAME to retrieve the service names and then check the /etc/services for the equivalent port values to open on your firewall.