A db2 trigger between two tables in two databases

[Arun R Pai]

I would like to come up with a solution, a trigger or something for satisfiying the below requirement.

If I do an insert in to table1 of database1 then it should trigger an insert to an another table2 in database2. I hope database1 can be a physical db in server and database2 can be remotely catalog on the same server itself.


Please advice me with some solution to do an automated process like trigger.

[vijay2082]

You probably need a solution like replication or federation. Check out the one that will suit you most and test/implement accordingly.

Cheers, Vijay