DSXchange

A DB2 database cataloged remotely is only effective within an instance. Outside of the instance, it is invisible. The problem is how to associate the Datastage server with a DB2 instance, and how to determine which DB2 instance is associated with the Datastage server? Can a Datastage server be associated with multiple DB2 instances , so databases cataloged in multiple DB2 instances can be seen by the same project in Datastage? And how?

Thanks in advance,

Steven Huang :D

We had a lot of problems with this in the start. You can have only one db2 instance associated with DataStage (don't know out of my head but probably with a reference in dsenv).

The only workable way we found to access more than one instance is to catalog the remote database in your local instance.

Ogmios