Connecting to DB2 Databases

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
condond
Participant
Posts: 3
Joined: Tue Mar 06, 2007 4:01 pm
Location: HOU

Connecting to DB2 Databases

Post by condond »

Is it possible to make connections to different versions of MVS DB2 from a single DataStage client. We are pulling data from two different MVS sytems via DB2 Connect and they are at different levels of DB2 one is a Version 7 and the other Version 8. The question is can we set up to pull from these at the same time.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Have you tried it?

I suspect there may be some issues because DB2INSTANCE environment variable can only have one value set at a time.

There is a manual available (currently in its third version) on connectivity to DB2. It's an invaluable item of ammunition for your armoury. Search the forum to find a link to it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply