Liniking two tables in two different database machines

[rkumar28]

Hi,

I have worked on Oracle database and am new to DB2 UDB. Is there a way I can join two tables in two different databases on diferent machines. Like in Oracle we have DB links. Do we have anything similar like DB Link in DB2 UDB.

I am trying to do something like below:

select Col1, Col2, Col3
from
table1, ----> This is in QA Box.
table2 ---->Table two is in Production box


Any advice will be appreciated.

Thanks

 

[blom0344]

Oracle DB links work between Oracle databases AFAIK. You should look for federated databases or federation. I think the enterprises versions of Oracle / DB2 should be able to communicate with each other.

Ties Blom

 

[rkumar28]

Thanks for the response. I am not trying to link DB2 table with Oracle. Actually I am trying to link two tables in DB2 that are on different databases....one in Production and the other in QA....

Thanks

 

[blom0344]

I think one of the databases should be on a federated server. You can then create a DB2 wrapper for the other source. Are you in the process of trying to compare data from 2 databases?

Ties Blom