BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Install ODBC driver for DB2 and configure BODI to use it


 
Search this topic... | Search DI: Installation, Administration, and Connectivities... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Installation, Administration, and Connectivities  Previous TopicPrint TopicNext Topic
Author Message
Smegheadking
Forum Member
Forum Member



Joined: 12 Dec 2011

Posts: 6



PostPosted: Mon Dec 12, 2011 10:54 pm 
Post subject: Install ODBC driver for DB2 and configure BODI to use it

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 <LoadLibrary> 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=<Same path as what was added to LD_LIBRARY_PATH down to the libdb2.so>
IPADDRESS=<IP address of the DB2 database server>
PORT=50000
UID=<TheUsername>
PWD=<ThePassword>


But I still get the same error as above:

System call <LoadLibrary> 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.
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19111
Location: Bratislava


flag
PostPosted: Mon Dec 12, 2011 11:42 pm 
Post subject: Re: Install ODBC driver for DB2 and configure BODI to use it

[Moderator Note: Moved from General Discussion to DI: Installation, Administration, and Connectivities]
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10590
Location: Germany


flag
PostPosted: Tue Dec 13, 2011 4:16 am 
Post subject: Re: Install ODBC driver for DB2 and configure BODI to use it

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
Product Manager Data Services
SAP AG
“The opinions expressed in this post are my own views and not those of SAP.”

PLEASE SUPPORT THIS: Run one ATL job and tell us the benchmark result. Details to be found here.
Back to top
Smegheadking
Forum Member
Forum Member



Joined: 12 Dec 2011

Posts: 6



PostPosted: Tue Dec 13, 2011 10:02 am 
Post subject: Re: Install ODBC driver for DB2 and configure BODI to use it

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!
Back to top
Smegheadking
Forum Member
Forum Member



Joined: 12 Dec 2011

Posts: 6



PostPosted: Tue Dec 13, 2011 4:35 pm 
Post subject: Re: Install ODBC driver for DB2 and configure BODI to use it

I wonder if I need a DB2 client installed as well as the ODBC driver?
Back to top
Smegheadking
Forum Member
Forum Member



Joined: 12 Dec 2011

Posts: 6



PostPosted: Thu Dec 15, 2011 4:52 pm 
Post subject: Re: Install ODBC driver for DB2 and configure BODI to use it

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 <ALIAS> <user> <password>

works great, so does

db2
connect to <ALIAS> user <USER>

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

System call <LoadLibrary> 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=<ip address>
TcpPort=<tcp port>
IsolationLevel=CURSOR_STABILITY
LogonID=<user>
Password=<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.
Back to top
Smegheadking
Forum Member
Forum Member



Joined: 12 Dec 2011

Posts: 6



PostPosted: Mon Dec 19, 2011 11:04 am 
Post subject: Re: Install ODBC driver for DB2 and configure BODI to use it

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.
Back to top
Smegheadking
Forum Member
Forum Member



Joined: 12 Dec 2011

Posts: 6



PostPosted: Tue Dec 27, 2011 1:40 pm 
Post subject: Re: Install ODBC driver for DB2 and configure BODI to use it

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!
Back to top
boalikhan
Forum Member
Forum Member



Joined: 27 Oct 2015

Posts: 3



PostPosted: Thu Dec 07, 2017 12:27 pm 
Post subject: Re: Install ODBC driver for DB2 and configure BODI to use it

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 <LoadLibrary> 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.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Installation, Administration, and Connectivities  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0158 seconds using 17 queries. (SQL 0.0034 Parse 0.0003 Other 0.0121)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo