Start a conversation

DB2 Connection - Scriptcase 8.1 - Linux

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 : 


PHP 5.6
PHP 5.4

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

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Ronyan Alves

  2. Posted
  3. Updated

Comments