Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

MQ ROLLBACK?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries
View previous topic :: :: View next topic  
Author Message
anshuljain26

New User


Joined: 04 Apr 2010
Posts: 37
Location: Chandigarh

PostPosted: Tue Aug 02, 2011 12:31 am    Post subject: MQ ROLLBACK?
Reply with quote

Hi,

To fix an issue in our application, we require an MQ rollback. Following is the scenario:

1)Program A puts message on MQ ABC.
2)MQ ABC, has trigger Y, so it invokes a transaction XX which further invokes a program B.
3)Program B is invoked in MQ region which further invokes a program C in ZZ region i.e. in AOR
4)Now, for a condition i want to rollback the changes and put the same message on MQ, that program C recieved via B, and B through MQ so that when Rollback is issued message on MQ ABC is there.

Way I am trying:
I am issuing EXEC CICS ROLLBACK END-EXEC.

This definitely rollback the DB2 changes and CICS changes, but the message from MQ ABC was consumed.

What i dont want to try:

Definitely, we can write the same message back on MQ from prog C, but that's the last option we have kept with us, coz that will require lot of access and permissions.


Could you please help me.

I am sorry for such a long message but thought of describing the situation completely. Please let me know in case any further information is required.

Thanks.

Anshul
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Aug 02, 2011 12:53 am    Post subject:
Reply with quote

suggest you look into RRSAF. if your are doing MQS and DB2 within the same transaction,
some analyst at your place did a great job of not doing his/her job.
Back to top
View user's profile Send private message
anshuljain26

New User


Joined: 04 Apr 2010
Posts: 37
Location: Chandigarh

PostPosted: Tue Aug 02, 2011 1:16 am    Post subject:
Reply with quote

Thanks, Dick.

i will look into RRSAF, between what are the design issues for MQS & DB2 within same transaction.

Could you please help me understand?

Thanks.
Back to top
View user's profile Send private message
anshuljain26

New User


Joined: 04 Apr 2010
Posts: 37
Location: Chandigarh

PostPosted: Tue Aug 02, 2011 2:05 am    Post subject:
Reply with quote

I was not able to find much information on RRSAF. Could you please help?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Aug 02, 2011 1:22 pm    Post subject:
Reply with quote

Read chapter 3 in ABCs of z/OS System Programming: Volume 5
that will provide you with the basics.

This is not something that you can implement without the support of your Sys-programmers, CICS, MQS, (Websphere) and DB2 support people.

Since RRSAF is a paid-for option, your site may have decided to not purchase RRSAF.
which means you are back at the begining dealing with multiple resource backout.

Since DB2 commit/rollback is normally controlled via CICS,
don't understand why your site does not have MQS already tied it.

It may be that instead of a CICS ROLLBACK, you need to do a DB2 RRS Rollback or make use of the MQS RRS Rollback.
the above I leave to you to find in the MQS/Websphere documentation.
Back to top
View user's profile Send private message
Garry Carroll

Active Member


Joined: 08 May 2006
Posts: 991
Location: Dublin, Ireland / Edinburgh, Scotland

PostPosted: Tue Aug 02, 2011 2:17 pm    Post subject:
Reply with quote

What are your setting for MQGMO-OPTIONS ? To be able to rollback the MQ message you need to specify MQGMO-SYNCPOINT, otherwise the MQGET will consume the message immediately. Rollback will reinstate the message in the same position on the queue, so be sure to check the BackoutCount to prevent interminable loop.

Garry.
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1224
Location: Israel

PostPosted: Tue Aug 02, 2011 3:17 pm    Post subject: Reply to: MQ ROLLBACK?
Reply with quote

anshuljain26 wrote:
Way I am trying:
I am issuing EXEC CICS ROLLBACK END-EXEC.

Funny, I cannot find this command in the documentation icon_question.gif
I always use EXEC CICS SYNCPOINT ROLLBACK END-EXEC and it backs out all recoverable resources, DB2 and MQ...
Maybe the MQ queue is not part of the recoverable resources
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts TWA variable having junk value after ... Gopalakrishnan V CICS 1 Tue May 13, 2014 7:59 pm
No new posts Handle ROLLBACK in EXCI interface Pandora-Box CICS 12 Fri Sep 21, 2012 2:38 pm
No new posts Rollback does not remove messages? Susan Talbot Java & MQSeries 5 Fri Sep 23, 2011 11:38 pm
No new posts Error in CICS SYNCPOINT ROLLBACK enrico-sorichetti CICS 4 Thu Mar 31, 2011 6:22 pm
No new posts Explcit ROLLBACK used in COBOL code. Rijit COBOL Programming 11 Wed Mar 23, 2011 12:24 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us