14. Installing DB2 Express-C on Mandriva Linux 2007

Before proceeding, please ensure that you have read Section 5, “Installation considerations and planning” and Section 6, “Installing DB2 Express-C”.

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.

These installation notes are based on a single-partition installation using the 2.6.17-5mdvlegacy kernel.

14.1. Installation notes

Note that root logins are not allowed in Mandriva, so you will need to log on as another user, then run the su -l command from a terminal session to gain root access before you launch the ./db2setup command.

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 drakrpm package utility to install the necessary C++ compatibility libraries:

libstdc++5-3.3.6-3mdk
libstdc++6-4.1.1-3mdk

Installation succeeded after installing the C++ libraries.

14.2. Post-installation notes

Basic test results (see Section 21, “Installation and operation test plan” 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 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).

Open the Mandriva Control Center, choose the Security tab, and then the "Set up a personal firewall..." icon. In the firewall setup panel, click the "Advanced button and add 523/udp 523/tcp 50001/tcp to the Other ports text box. Click "OK until the firewall setup is complete.

Note that you will need to add another new TCP rule to allow firewall access if you create any additional instances later.