DSXchange

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.

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.