Connecting to DB2 using Datastage

dsxdev · Post by **dsxdev** » Thu Feb 03, 2011 12:44 pm

Hi
Trying to setup connection from Datastage 7.5.3 on server A (Unix) to DB2 UDB on Server B (Unix) using a non-interactive id. Did any one work on this kind of scenario and what are the settings to be taken care on Db2 UDB database and the Datastage server.

Regards
dsxdev

ThilSe · Post by **ThilSe** » Sun Feb 06, 2011 3:35 am

It's couple of years I connected to DB2 but if i remember correctly you have to setup .rhosts file in home directory of the Etl Id (or Db Id?) in each of the nodes used. The rhosts file contains server name and user id and it should have read permission.

Thanks
Senthil

ray.wurlod · Post by **ray.wurlod** » Sun Feb 06, 2011 12:22 pm

Step 1 is to read the Connectivity Guide for DB2. This is part of your standard manual set.