Error Connecting to Remote DB2 Server

manishk · Post by **manishk** » Wed Feb 22, 2006 8:48 pm

Hi,

My DataStage Server is in one Unix box (Say Server A) and Database Db2 Server (Say Server B)is on other box.
The connection has been defined in the Server A which points to the Db in Server B. Through telnet, from Server A, i am able to connect to the remote database as well i am able to qry the database. But when i try this through DataStage i am not able to connect.
Please let me know if any engine has to be installed in Servr B or any configuration parameter has to be changed in Server A.

Thanks
Manish

ArndW · Post by **ArndW** » Thu Feb 23, 2006 2:00 am

Manish,

Installing a DB/2 connection for PX is a bit more involved. There is a whole list of configuration settings and prerequisites in the installation guide, have you gone through those? Also, can you issue a "db2 connect ..." on your DataStage UNIX server "A" to the DB on "B"?