Configuring DB2 connect for Bussiness Objects XI on Unix server

[Former Member]

Hello,

We have installed DB2 Connect on the same unix server where BO is running.

We are trying to connect BO to DB2 on the Mainframe.

We are able to connect from the db2 prompt on the Unix to the DB2 on Mainframe.

We created the instance, and LD_LIBRARY PATH, CLASSSPATH, PATH, DB2INSTANCE Env. vars. are also pointing to the right location.

Do I need perform additional setup(s) for the BO, for it to connect to the DB2?

Anyone know?

Thanks in advance.

-Shaista

[Former Member]

Hi,

Please suggest how to connect to the DB2 database from crystal report Designer using DB2 connect.

After report creation i want to publish the report to the repository so that i can view it in Infoview.

Please suggest!!!

[Former Member]

Hello,

did you find a solution?

I have to make a new installation of BO on a Linux server and the repository and datawarehouses will be on DB2.

What do I need to install for the connection from BO (XI 31 sp4) to DB2 (v.9.7)?

Thanks

Camillo

[Former Member]

Hi shaista,

I am having the same problem too. do u manage to find any solution ?

[Former Member]

I recommend that you check out the IBM Pattern book from the support site. You can do a search at support.businessobjects.com for 'Setup DB2 XIR2' if the link below doesn't work.

http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&ext...

As part of the setup, the instructions recommend sourcing a db2profile from the boe user's .profile. It also has some information on testing the connectivity to the database, and minimum patch requirements.

HTH.

[Former Member]

Tony, that link doesn't work, and the search returns nothing. Any further directions?