Hi Sandy,
If you enable identity_insert on a table, you can insert the values from the other databases. Since they maintain referential integrity there, they will on SQL side as well. The trick is not to generate new ids for records inserted but reuse those generated on DB2 side
Regards
Piotr
...and your only reply is slàinte mhath