ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » Mainframe, CICS, TXSeries » SYNCPOINT - ROLLBACK

Post new topic  Reply to topic
 SYNCPOINT - ROLLBACK « View previous topic :: View next topic » 
Author Message
chandana06
PostPosted: Mon Apr 24, 2006 5:01 am    Post subject: SYNCPOINT - ROLLBACK Reply with quote

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
View user's profile Send private message
chandana06
PostPosted: Mon Apr 24, 2006 5:08 am    Post subject: Reply with quote

Apprentice

Joined: 26 Jan 2006
Posts: 32

Sorry i put it in the wrong forum. Replies are most welcome
_________________
Regards,

Chandana
Back to top
View user's profile Send private message
Mr Butcher
PostPosted: Mon Apr 24, 2006 5:34 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » Mainframe, CICS, TXSeries » SYNCPOINT - ROLLBACK
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.