Page 1 of 1

Connecting to DB2 Databases

Posted: Tue Apr 10, 2007 12:06 pm
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.

Posted: Tue Apr 10, 2007 1:53 pm
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.