DB2 Connection - Scriptcase 8.1 - Linux

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\DEBIANCENTOS\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

    • Related Articles

    • Manual Update - Linux

      Before performing any procedure we recommend performing a backup of your projects. To back up Scriptcase: Go to Options > Settings, in the side menu go to Services > Backup. A file (.ZIP) will be generated with all your projects, save this file to a ...
    • Informix Connection - Scriptcase 8.1 - Linux

      To enable the connection to Informix 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 ...
    • Oracle Connection - Scriptcase 8.1 - Linux

      To enable the connection to Oracle 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
 ...
    • Oracle Connection - Scriptcase 9 - Linux 64 Bits

      This procedure will only work if you have a Scriptcase manual installation in your server. Installing PHP 7.0 Installing the Scriptcase Manually To connect with Oracle in a Linux System, we must follow these steps below: Step 1 -  Installing these ...
    • DB2 connection - Scriptcase

      Enabling DB2connection on Scriptcase:   1. Download the instant client of DB2 form the url below or download the file in the final of this tutorial.   - Data Server Driver Package 10.5 - http://www-01.ibm.com/support/docview.wss?uid=swg27016878 ...
    • Popular Articles

    • Examples for diagrams

      This tutorial shows how you can import and use the new examples for diagrams released with Scriptpcase V9.2.16.  The applications were created using the components: Jsmind, JKanban e Orgchart.  - Sample 1: Mind Map diagram Click here to  execute the ...
    • Manual Update - Windows

      Before performing any procedure we recommend performing a backup of your projects. To back up Scriptcase: Go to Settings > Administration, in the side menu go to Services > Backup. A file (.ZIP) will be generated with all your projects, save this ...
    • PHP functions necessary for ScriptCase

      In PHP , there are some essential functions for the operation of Scriptcase .  On some servers , these functions are disabled , this makes the Scriptcase not work properly.  If you're using a shared hosting server, you'll need to contact the host ...
    • Oracle Connection - Scriptcase 9 - Linux 64 Bits

      This procedure will only work if you have a Scriptcase manual installation in your server. Installing PHP 7.0 Installing the Scriptcase Manually To connect with Oracle in a Linux System, we must follow these steps below: Step 1 -  Installing these ...
    • Using friendly URL

      The friendly URL was included from Scriptcase 7, in order to make the URL, of the applications generated by Scriptcase, cleaner and easier to associate them with applications. For example, using friendly URLs the link to a Scriptcase application ...