How to associate Datastage server with a DB2 instance?

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
olgc
Participant
Posts: 145
Joined: Tue Nov 18, 2003 9:00 am

How to associate Datastage server with a DB2 instance?

Post by olgc »

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
Top
ogmios
Participant
Posts: 659
Joined: Tue Mar 11, 2003 3:40 pm

Re: How to associate Datastage server with a DB2 instance?

Post by ogmios »

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
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”