Hello All
I know about two phase commit and my question is regarding the transaction boundries crossing multiple resources like DB, Mainframe, MQSeries to staffware and others.
Our scenario is
EJB starts a transaction and call Oracle DB then calls CICS to do some commit and then calls DB2 and finally calls staffware to move the item from one staffware queue to another.
In other transactions the above four resources are used in different order.
Now can I use two phase commit in this circumstance. I am calling CICs using ECI and using a transaction name.
If say after calling ORacle, DB2 and finally calling CICS fails how can the trransaction manager does the rollback of cics trransactions?
Does this work of transaction manager or we ave to write a trransaction in CICS Please explain?