To enable the connection to DB2 on Linux, we must perform the following steps:
Prerequisites
Step 1 - Add the i386 architecture and install the packages below :
| UBUNTU\DEBIAN | CENTOS\RHEL |
| - sudo dpkg —add-architecture i386 - sudo apt-get update - sudo apt-get install libaio1:i386 - sudo apt-get install libncurses5:i386 - sudo apt-get install alien - sudo apt-get install gcc-multilib g++-multilib - sudo apt-get install libpam0g:i386 - sudo apt-get install ksh:i386 - sudo apt-get install unixodbc-dev:i386 unixodbc:i386 | - sudo yum update - sudo yum install libaio-devel.i686 - sudo yum install libaio.i686 - sudo yum install glibc.i686 - sudo yum install compat-libstdc++-33.i686 - sudo yum install glibc-devel.i686 - sudo yum install libstdc++.i686 - sudo yum install libstdc++.i686 - sudo yum install pam.i686 - sudo yum install ncurses-devel.i686 - sudo yum install unixODBC.i686 - sudo wget ftp://195.220.108.108/linux/centos/6.7/os/i386/Packages/ksh-20120801-28.el6.i686.rpm - sudo yum install ksh-20120801-28.el6.i686.rpm - sudo yum install nano |
Step 2 - Download DB2 DSDriver :
DSDriver DB2 v10.5fp5_linuxia32
Step 3 - Download PHP extension :
Step 4 - Copy the extension to the folder ext scriptcase :
- sudo cp ibm_db2.so /opt/NetMake/v81/components/apache/ext/
Step 5 - Edit and add on the end of php.ini file the db2 extension :
- sudo nano /opt/NetMake/v81/components/apache/conf/php.ini
- extension=ibm_db2.so
Step 6 - Install the DB2 DSDriver :
- sudo mkdir /opt/IBM
- sudo mkdir /opt/IBM/Db2/
- sudo cp v10.5fp5_linuxia32_dsdriver.tar.gz /opt/IBM/Db2
- sudo cd /opt/IBM/Db2/
- sudo tar -zxf v10.5fp5_linuxia32_dsdriver.tar.gz
- sudo cd dsdriver - sudo ksh installDSDriver
Step 7 - Restart apache :
- sudo /etc/init.d/apachesc81 restart