Db2 Connectivity from Datastage

Ragunathan Gunasekaran · Mon Mar 15, 2010 9:57 am

Hi ,

I am having a DB2 Server sitting on iseries machine and my Datastage 8.1 sits on a linux platform. I have tried adding contents to the uvodbc.config and the .odbc.ini files but yet to get something for DB2 into the DSenv files.

Can you please advise me what should be the content that i have to make for configuring the Db2 b/w the datastage and the actual database.

Kind help is appreciated

Bongo51 · Post by **Bongo51** » Tue Sep 14, 2010 3:28 am

Hello,

sorry for the late reply. Please review this link about DaatStage connecting to DB2:

http://www.ibm.com/developerworks/data/ ... dm-0609xu/

kduke · Post by **kduke** » Tue Sep 14, 2010 4:21 pm

There are several types of DB2. They work very differently. The mainframe version is very different from AS400 and from the UNIX version. The ODBC connections and API connections need to know which version you are connecting to.