Open topic with navigation

Connecting with IBM DB2

Pre requirements

 

If all the requirements are met, then your DB2 extension is enabled, in this case, you can 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.

If not, then follow the steps below to enable the extension, DB2:

 

Enabling the extension

1. First, do the download of the instant client compatible with the architecture of your operating system, x64 or x86 bits

 

2. After downloading the file, follow the steps in the installation wizard clicking on next and keeping the default values.


Image1: Configuring the DB2 Instant Client.

 

3. Accept the terms and continue with the installation.


Image2: Configuring the DB2 Instant Client.

 

4. Click on Next, and keep the default values of the installer


Image3: Configuring the DB2 Instant Client.

 

5. Click on Installer, to start the installation process


Image4: Installing the DB2 Instant Client.

 

6. Click on finish, to finish the installation.


Image5: Installing the DB2 Instant Client.

 

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.