I'm on DB2 8.1 WG and I'm wondering about propagating data to a remote DB system that's already cataloged in the db directory. Is it possible to use a simple trigger to do this? If not, what's the best way to do this? DB2 replication?
When you say that the remote DB is cataloged in the DB directory, do you mean through Ferderation or that there is just an entry in the DB catalog (LIST DB DIRECTORY). If the system is Federated then triggers will work for this. If not, the trigger would need a connection to the remote DB, which it cannot do. You will need to use Replication for this scenario.
If you potentially might have more than 1 remote DB to copy the data to, I would strongly suggest you use Replication.