Hi all,

I'm looking to see if DB2 provides the same functionality as Oracle's "Database Link" and SQL Server's "Linked Server".

I have two different DB2 9.7 machines - machineA and machineB. I want to copy the rows of a particular table in machineA into the same table in machineB. The Oracle / SQL Server SQL looks similar to the following, assuming the links have been set up:
INSERT INTO machineB.userB.tableZ SELECT * FROM machineA.userA.tableZ

Note that I have already successfully implemented the a feature using links for Oracle and SQL Server. I just find it hard to believe that there is not somehting similar for DB2. I have tried Googling but came up with some vague results. Your help and advice is appreciated.

Thanks and kind regards,
Jason.

In DB2 it is called Federation. Check it out in the manuals.

Andy

Hi Andy,

Thanks for that. I've read about federation as a solution on several websites including this one and am currently looking into it.

I'm assuming it's like database link / server link but a bit more involved?

Kind regards,
Jason.

I do not know the Oracle or SQL Server methods. But to access a table on a remote database as if it was part of the connected database, in DB2 you use Federation.

Andy

Excellent Andy! Thank you kindly.

Jason.

Hi all,

Thanks for the help. Many months ago I successfully implemented DB2 federation to link two remote database servers together. I have since written an entry on my blog about how I achieved it. I hope people find it useful and that it saves them time.

Surfjungles Technology Blog: Linking DB2 databases together via federation

Kind regards,
Jason.