Open topic with navigation

Connecting with IBM DB2

We will see the steps we enable for DB2 on Linux.

Prerequisites

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

2 - Download DB2 DSDriver :

DSDriver DB2 v10.5fp5_linuxia32

3 - 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

4 - Restart apache :

- sudo /etc/init.d/apachesc81 restart

Once it is correctly installed we are able to create a connection on Scriptcase

Open topic with navigation

Drivers DB2

Drivers DB2

Currently Scriptcase offers four drivers to connect with the DB2 database: DB2, DB2 ODBC Native , DB2 Generic ODBC and DB2 Generic ODBC 6 or lower.

You can see the features below:

DB2 ODBC Native ( Recommended ) : Allows the connection to be made using the native driver of the DB2 database.

DB2 : Allows the connection to be made using the native driver of the DB2 database.

DB2 Generic ODBC : Allows the connection to made using a DB2 ODBC Data Source.

DB2 Generic ODBC 6 or lower: Allows the connection to be made using using a DB2 6 or lower ODBC Data Source.

Creating a Connection on Scriptcase

Connecting to DB2 from Scriptcase

Open topic with navigation

Now we’ll access Scriptcase from Scriptcase from the browser and create a connection with the DB2 database.

Step 1: Access your Scriptcase, for example, http://localhost:8081/scriptcase/ on the toolbar go to the marked icon in the image below, referring to “New Connection”.

Step 2: After clicking “New Connection”, the page for creating connections will appear, click on the DB2 database image.

Step 3: On the following image, place the required information:

For more details on configuring the connection of the database click on Advanced

Filter - Clicking on this tab, the following page will appear:

Step 4: Always test your connection before saving, if the message “Connection Success” appears, then save the connection. If it fails to connect, revise the fields that were informed, especially Username, Password, Database and Server/Host.

Verify if the module is enabled in the diagnosis.