RE: Replication Opinions

["Chris Bipes" <chris.bipes@xxxxxxxxxxxxxxx>]

Remote journaling is the MY preferred method as it is still be supported
and enhanced by IBM.

Trigger with local data queue to post changes and program on remote end
reading a TCP/IP DDM Remote data queue is my second choice.

I also like to perform what I call field level updates.

Chain to local file with lock for update.  Compare before and after
value of field, if changed, compare before and current value of field.
If the same, change current to after value, if not, log the three values
into an audit / error file and skip update of that field. Update record.

Rinse and repeat for each field in the file.

Of course a delete is just that a keyed delete, no reason to read the
local file. And an insert is just a write to the file.