DSXchange

Hi!

I have a problem regarding connectivity to a DB2 instance on a separate LPAR and I wish to use the DB2 Enterprise Stage. Currently we are using DB2 Enterprise Stage within whom we've specified the name of the DB2 Instance which recides on the same LPAR. This works great, however we have a demand upon us to have DB2 on a separate LPAR and I don't know how to make DB2 Enterprise Stage connect to it!?!

A workaround would be to use DB2 API or DB2 Load togheter with DB2 Connect but surely there must be another way! Please help...

There is a 22 page document available from IBM support that describes setting up for remote DB2 access. That there's 22 pages ought to suggest that the process is non-trivial. You will also need to talk to your sales rep about getting an additional copy of DataStage to run on the DB2 machine - this should come at no cost, because they have to supply it to fix what they've admitted is a bug in the DB2 Enterprise stage's mechanism for accessing remote DB2 databases. Perhaps someone ought to ask "them" to upload a copy to the DeveloperNet download site?

Ray,
Wouldnt he require federate links to link between the two databases?
Correct me if i am wrong.

That's one of those wonderful "it depends" questions. Get the document and see which technique is most appropriate.

Thanks for the input! I'll guess i will try and find that document and see what input it will give me...

Feedback....

We solved the issue by DB2 documentation specifing the use of DB2 Connect mapping remote db2 as local db2, not using federated databases, just plain node configuration.