IBM DB2 Installation

Notes

Using DB2 with PHP requires the installation of 2 drivers, ibm_db2, and pdo_ibm. The following instructions are intended as a guide. Knowledge of compiling applications is necessary for this process.

Linux

Debian/Ubuntu/Mint/Etc

IBM_DB2

1. Get the prerequisites

   • $ sudo apt-get install build-essential php5-dev php-pear ksh zip

2. Download the DS Driver package from IBM (login required, free.) https://www-01.ibm.com/marketing/iwm/iwm/web/preLogin.do?source=swg-idsdpds
3. Extract the DS Driver package to a directory of your choosing. I made a directory in /opt/ibm for this, and will use this directory throughout the examples.

   • $ sudo mkdir /opt/ibm

   • $ sudo tar -zxvf ibm_data_server_driver_package_linuxx64_v10.5.tar.gz -C /opt/ibm

4. Change directory to the extracted files and make the installer executable

   • $ cd /opt/ibm/dsdriver

   • $ sudo chmod +x installDriver

5. Install the DS Driver package

   • $ sudo ksh installDriver

   • You should see feed back on the screen indicating successful installation. If you do not, please troubleshoot and resolve before proceeding
6. Build and install the module with PECL. The installer will ask you for the DB2 Installation Directory, which will be /opt/ibm/dsdriver

   • $ sudo pecl install ibm_db2

   • DB2 Installation Directory? : /opt/ibm/dsdriver

7. Enable the module in PHP
   • Use your text editor of choice (I use vim) to add an ibm_db2.ini file

   • $ sudo vim /etc/php5/mods-available/ibm_db2.ini

   • The file should have a single line

   • extension=ibm_db2.so

   • Save the file. Then enable the module the php enmod

   • $ sudo php5enmod ibm_db2

8. Confirm installed and working in PHP

   • $ php -m

   • You should not see any errors at the top of the module list, and ibm_db2 should be in the module list.