| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| SYNCPOINT - ROLLBACK |
« View previous topic :: View next topic » |
| Author |
Message
|
| chandana06 |
 Posted: Mon Apr 24, 2006 5:01 am Post subject: SYNCPOINT - ROLLBACK |
 |
|
Apprentice
Joined: 26 Jan 2006
Posts: 32
|
Hi All,
i have MQ & IMS online program. This program reads a record from the queue and updates the IMS database.
My requirement is that when ever there is a IMS abend i need to delete the corresponding record from queue.
I was planning to do a SYNCPOINT and then abend the program so that the queue record gets deleted and then abend caused rollback of the IMS database.
But this program is linking to another program which is doing certain DB2 updates. I need to roll back these DB2 updates also. I tried EXEC SQL ROLLBACK before SYNCPOIT in my program but it is not working.
Is there any other way to achieve this?
Regards,
Chandana
_________________
Regards,
Chandana |
|
| Back to top |
|
 |
| chandana06 |
| Posted: Mon Apr 24, 2006 5:08 am Post subject: |
|
|
Apprentice
Joined: 26 Jan 2006
Posts: 32
|
Sorry i put it in the wrong forum. Replies are most welcome 
_________________
Regards,
Chandana |
|
| Back to top |
|
|
| Mr Butcher |
| Posted: Mon Apr 24, 2006 5:34 am Post subject: |
|
|
Padawan
Joined: 23 May 2005
Posts: 1716
|
you want to backout the database changes, but delete the mq message? whow! this looks very inconsistent to me.
anyway, you can get the message without syncpoint, then it is away in any case after the get, no matter who abends.
_________________
Regards, Butcher |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
