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...
Connecting to DB2 using DB2 Enterprise Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Mon Nov 14, 2005 8:38 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 6
- Joined: Mon Nov 14, 2005 8:38 am
-
- Participant
- Posts: 6
- Joined: Mon Nov 14, 2005 8:38 am