Install ODBC driver for DB2 and configure BODI to use it

dataservices administration
1

Hi everyone,

Thanks in advance for any advice.

DB2 Driver I’m using : IBM DB2 Driver for ODBC and CLI
OS is 64 bit Suse Linux
BODI version is XI
DB2 database version is 9.5

I am trying to configure Business Objects Data Integrator to run with DB2 tables as targets / sources.

So far, when I try running a simple job with one Data Flow that reads a DB2 table and attempts to create a flat file from it, I get an error stating :

System call to load and initialize functions failed for <libdb2.so>. Please make sure the shared library is installed and located correctly.

To install the DB2 ODBC driver :

I have copied the uncompressed IBM DB2 Driver for ODBC and CLI files into a directory on the server running BODI.

I’ve added the folder path to the driver to LD_LIBRARY_PATH.

I’ve created a DSN entry in the odbc.ini file, however I’m not sure if it’s correct.

[DB2_DSN]
Driver=
IPADDRESS=
PORT=50000
UID=
PWD=

But I still get the same error as above:

System call to load and initialize functions failed for <libodbc.so>. Please make sure the shared library is installed and located correctly.

In searching Data Integrator documentation, there’s not much information in the way of how to set up BODI to use a new ODBC data source, DB2 or otherwise.

Does anyone else have BODI using DB2? I would imagine several do. Where could I go to find information about installing the DB2 ODBC driver properly for BODI?

I have tried several google searches and come up with steps that seem to be close, but upon following them, the same error appears or I’m unable to follow all of them for one reason or another.

Is this covered in the Technical manuals pdfs that can be launched from within the BODI designer? I’ve looked but haven’t found anything worthwhile.

Any suggestions or anecdotal evidence that BODI can use DB2 as a data source would be helpful. Perhaps I shouldn’t even be going down the ODBC route, is there an OLE DB or other solution I should be investigating?

Again, thanks for any help anyone would have.

Smegheadking (BOB member since 2011-12-12)

2

[Moderator Note: Moved from General Discussion to DI: Installation, Administration, and Connectivities]

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Is DS the 64nit version or the 32bit version? And the library, does that match it? Remember, a 32bit application cannot load a 64bit library and vice versa.

Werner Daehn :de: (BOB member since 2004-12-17)

4

The driver is the 64 bit version.

Is what you’re telling me that I should check the bit version of BODI to see if it’s a 32 or 64 bit version because if BODI is 32 bit then I need a 32 bit driver?

That would make sense, I chose a 64 bit driver because the OS is 64 bit.

I’m not sure whether we have the 32 or 64 bit BODI version installed, but I’ll check on that and get back with you.

Thanks for your input!

Smegheadking (BOB member since 2011-12-12)

5

I wonder if I need a DB2 client installed as well as the ODBC driver?

Smegheadking (BOB member since 2011-12-12)

6

I’ve been looking at this for a few days now…

I have installed a DB2 client and can connect to the database using a command line via Putty.

isql -v

works great, so does

db2
connect to user

However I’m still getting the same error via Data Integrator:

System call to load and initialize functions failed for <libdb2.so>. Please make sure the shared library is installed and located correctly.

The $LINK_DIR/odbc/lib contains a libdb2.so file, as do several other folders where various other driver flavors I’ve tried are.

The $LINK_DIR/odbc/odbc.ini file entry for the new connection I’m trying to set up references :

[ALIAS]
Driver=$LINK_DIR/odbc/lib/libdb2.so
Database=ALIAS
DynamicSections=200
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=
TcpPort=
IsolationLevel=CURSOR_STABILITY
LogonID=
Password=
WithHold=1

Here’s more info if anyone is willing / able to lend a hand:

DB2 version 9.5
OS running Data Integrator server : SuSE Linux 9 Service Pack 1
Drivers tried:
v9.5fp8_linuxia32_odbc_cli
v9.5fp8_linuxppc64_dsdriver
v9.5fp8_linuxia32_client
v9.5fp8_linuxx64_client
v9.5fp8_linuxx64_dsdriver --> seems the most promising

Any thoughts? I appreciate any insight someone might have.

Smegheadking (BOB member since 2011-12-12)

7

I’ve got it working. Now I’m distilling what steps contributed to it working. I think I was using the wrong driver all along, things started going better when I downloaded the drivers from SAP instead of IBM.

I’ll post the resolution when I have something concise.

Smegheadking (BOB member since 2011-12-12)

8

I found the problem.

During the installation, I needed to restart the Data Integrator service, which in our documentation had us run a script that had a statement to update the LD_LIBRARY_PATH…

I updated that statement to include the files from the driver and it worked perfectly!

Smegheadking (BOB member since 2011-12-12)

9

I am running into the same problem, we currently have DB2 LUW database on Linux box which are connecting from a the job server installed on AIX box 64 bit and Designer on a 32 bit box on Windows XP.

We ran the DB2 connect utility from AIX box and we are able to connect to the DB2 LUW on Linux but when I execute a job from Designer or Management console it gives the below error

System call to load and initialize functions failed for </usr/opt/db2_08_01/lib64/libdb2.a>

Please make sure the shared library is installed and located correctly.

boalikhan (BOB member since 2015-10-27)