DB2 Message Queue Replication

WBlaustein · Post by **WBlaustein** » Tue Feb 12, 2013 7:05 pm

Had a requirement to load data into DB2 and MessageQueue at the same time. Incase if any one of them aborted the other one has to Rollback as well.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 12, 2013 11:49 pm

You might investigate the Distributed Transaction stage, but I suspect that rollback won't be possible. Reversal may, of course, be designed in if every record is identified with the job run that inserted/updated it. Reversing deletions requires capture of a before-image.