IBM DB2 Installation

From DreamFactory
Jump to: navigation, search
(Created page with "==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 applicati...")
 
 
(19 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
==Free DB2 Instance==
 +
 +
IBM offers a free DB2 instance which can be used for development purposes. Create an account at [[https://console.bluemix.net/dashboard/apps/ IBM Cloud]] to create an instance.
 +
 
==Notes==
 
==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.
+
DB2 access is accomplished using the PDO_IBM driver. Recently DreamFactory patched this driver to ensure PHP 7 compatibility. Please install using this GitHub readme as a guide [https://github.com/dreamfactorysoftware/PDO_IBM-1.3.4-patched PDO_IBM Patched]
  
−
==Linux==
+
For concrete example see the [[../../../APT/Ubuntu_16.04/Modules/IBM DB2_Ubuntu_16| Ubuntu 16.04]] instructions.
−
===Debian/Ubuntu/Mint/Etc===
+
−
====IBM_DB2====
+
−
#Get the prerequisites
+
−
#*<source lang=bash>$ sudo apt-get install build-essential php5-dev php-pear ksh zip</source>
+
−
#Download the DS Driver package from IBM (login required, free.) https://www-01.ibm.com/marketing/iwm/iwm/web/preLogin.do?source=swg-idsdpds
+
−
#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.
+
−
#*<source lang=bash>$ sudo mkdir /opt/ibm</source>
+
−
#*<source lang=bash>$ sudo tar -zxvf ibm_data_server_driver_package_linuxx64_v10.5.tar.gz -C /opt/ibm</source>
+
−
#Change directory to the extracted files and make the installer executable
+
−
#*<source lang=bash>$ cd /opt/ibm/dsdriver</source>
+
−
#*<source lang=bash>$ sudo chmod +x installDriver</source>
+
−
#Install the DS Driver package
+
−
#*<source lang=bash>$ sudo ksh installDriver</source>
+
−
#*You should see feed back on the screen indicating successful installation. If you do not, please troubleshoot and resolve before proceeding
+
−
#Build and install the module with PECL. The installer will ask you for the DB2 Installation Directory, which will be /opt/ibm/dsdriver
+
−
#*<source lang=bash>$ sudo pecl install ibm_db2</source>
+
−
#*<source lang=bash>DB2 Installation Directory? : /opt/ibm/dsdriver</source>
+
−
#Enable the module in PHP
+
−
#*Use your text editor of choice (I use vim) to add an ibm_db2.ini file
+
−
#*<source lang=bash>$ sudo vim /etc/php5/mods-available/ibm_db2.ini</source>
+
−
#*The file should have a single line
+
−
#*<source lang=bash>extension=ibm_db2.so</source>
+
−
#*Save the file. Then enable the module the php enmod
+
−
#*<source lang=bash>$ sudo php5enmod ibm_db2</source>
+
−
#Confirm installed and working in PHP
+
−
#*<source lang=bash>$ php -m</source>
+
−
#*You should not see any errors at the top of the module list, and ibm_db2 should be in the module list.
+

Latest revision as of 07:37, 19 July 2022

Free DB2 Instance

IBM offers a free DB2 instance which can be used for development purposes. Create an account at [IBM Cloud] to create an instance.

Notes

DB2 access is accomplished using the PDO_IBM driver. Recently DreamFactory patched this driver to ensure PHP 7 compatibility. Please install using this GitHub readme as a guide PDO_IBM Patched

For concrete example see the Ubuntu 16.04 instructions.

Retrieved from "https://wiki.dreamfactory.com/index.php?title=DreamFactory/Installation/Databases/IBM_DB2_Installation&oldid=34939"