Page 1 of 1

Connecting to DB2 using Datastage

Posted: Thu Feb 03, 2011 12:44 pm
by dsxdev
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

Posted: Sun Feb 06, 2011 3:35 am
by ThilSe
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

Posted: Sun Feb 06, 2011 12:22 pm
by ray.wurlod
Step 1 is to read the Connectivity Guide for DB2. This is part of your standard manual set.