How to catalog DSServer and DB2 present on other server

kiran259 · Post by **kiran259** » Mon Jan 07, 2008 2:44 am

Hi,
We know how to catalog connection for DB2 and DS which are in the same server.But,in an environment where DS is kept on one server and DB2 is on the other server,How do I catalog these two servers?
To be clear:
DS-IP addr1(172.16.1.103)
DB2 -IP addr2(172.16.1.104)

OS is IBM AIX.
DB2 is installed in DS server to access local database.If we want to access database present in the other server(1.104) how to create a connection between '1.103' and '1.104'??

Where should I do the changes in DS??

May I have a solution for this??

ray.wurlod · Post by **ray.wurlod** » Mon Jan 07, 2008 4:52 am

It helps if you think of DataStage from the perspective of the database server as "just another client application". Therefore, what you require on the DataStage server machine is exactly the database client software that you would need for any other client application.

kiran259 · Post by **kiran259** » Mon Jan 07, 2008 5:26 am

Ray,
I am still vague for your answer.Could you justify it ? I understand what you have said but I am not clear to implement.

ArndW · Post by **ArndW** » Mon Jan 07, 2008 5:31 am

set up DB2 on the server which is running DataStage so that you can issue "DB2 connect ..." to the DB2 instance. Once you can do that, you will be able to do the same thing from DataStage.