MVSFORUMS.com

edkir98 · Posted: Mon Sep 27, 2010 10:01 am Post subject: Connecting between 2 DB2 Systems

We have 2 DB2 subsytems - DB2A and DB2B. Both of them are in different location and they have their own set of tables and programs. I have a requirement where my program in DB2A has to access a table in the other DB2 system DB2B. How can i do this?

i have some suggestions but am not sure which will work.
1) Can i create a view for the table in DB2B in DB2A and use this view in my program?
2) Can we set up plans on both sides and do a bind so that I will run my program from DB2A, but issue a connect statement to DB2B.

Please help
_________________
Thanks

papadi · Supermod Joined: 20 Oct 2009 Posts: 594 Topics: 1

Read about DRDA - distributed relational database access.

Some info is here:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/conn/c0004776.htm
_________________
All the best,

di