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 » General Discussion » Long running transaction rolled forward

Post new topic  Reply to topic
 Long running transaction rolled forward « View previous topic :: View next topic » 
Author Message
MQMB&WAS
PostPosted: Thu Jul 09, 2020 10:44 am    Post subject: Long running transaction rolled forward Reply with quote

Centurion

Joined: 12 Jun 2016
Posts: 130

Hello all,

When a qmgr rolls forward a long running transaction to free up space, does the client application see any mqrc error codes?

Thanks
Back to top
View user's profile Send private message
bruce2359
PostPosted: Thu Jul 09, 2020 2:22 pm    Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9399
Location: US: west coast, almost. Otherwise, enroute.

What would an app do or not do in such a situation?
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live.
Back to top
View user's profile Send private message
gbaddeley
PostPosted: Thu Jul 09, 2020 3:44 pm    Post subject: Reply with quote

Jedi

Joined: 25 Mar 2003
Posts: 2495
Location: Melbourne, Australia

AFAIK, MQ does not roll forward. It either commits or backs out (rolls back) transactions. Backed out UOW results in MQ messages that were got under syncpoint to become eligible to be got by the app again. Backed out puts result in no message being hardened to a queue.

If the app receives a MQRC_BACKED_OUT from MQGET or MQPUT or MQPUT1, the app should proceed to backout all resources in the transaction.
_________________
Glenn
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Thu Jul 09, 2020 10:00 pm    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20696
Location: LI,NY

I'm going out on a limb here and expect that the original poster was talking about linear logging. So if you have a message on a queue that is long lived, it may happen that the log for that message needs to be rolled forward. This would happen behind the scene and be completely transparent to the user.

If you do not roll forward the risk is that you will exhaust your log space and the queue manager will stop. Have fun
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
MQMB&WAS
PostPosted: Fri Jul 10, 2020 12:39 am    Post subject: Reply with quote

Centurion

Joined: 12 Jun 2016
Posts: 130

fjb_saper wrote:
I'm going out on a limb here and expect that the original poster was talking about linear logging. So if you have a message on a queue that is long lived, it may happen that the log for that message needs to be rolled forward. This would happen behind the scene and be completely transparent to the user.

If you do not roll forward the risk is that you will exhaust your log space and the queue manager will stop. Have fun


Yes, linear logging.
Application reported they were facing mqtc host nit available errors and at the same time mq was logging this log forward messages. So just wondering if this log forwading would cause those mqrc host not available errors at the client.
Back to top
View user's profile Send private message
bruce2359
PostPosted: Fri Jul 10, 2020 3:12 am    Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9399
Location: US: west coast, almost. Otherwise, enroute.

MQMB&WAS wrote:

Application reported they were facing mqtc host not available errors and at the same time mq was logging this log forward messages. So just wondering if this log forwading would cause those mqrc host not available errors at the client.

What log forward messages? Please post the entire error message here.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live.
Back to top
View user's profile Send private message
tczielke
PostPosted: Fri Jul 10, 2020 4:33 am    Post subject: Reply with quote

Guardian

Joined: 08 Jul 2010
Posts: 939
Location: Illinois, USA

This MQTC session goes into some of the internals of the distributed MQ recovery log and why there is the "roll forward" message (which I did find a little confusing, at first).

https://www.mqtechconference.com/sessions_v2016/MQTC_v2016_More_Mysteries_of_the_IBM_MQ_Logger_final.pdf
_________________
Working with MQ since 2010.
Back to top
View user's profile Send private message
gbaddeley
PostPosted: Sun Jul 12, 2020 3:22 pm    Post subject: Reply with quote

Jedi

Joined: 25 Mar 2003
Posts: 2495
Location: Melbourne, Australia

MQMB&WAS wrote:
Yes, linear logging.
Application reported they were facing mqtc host nit available errors and at the same time mq was logging this log forward messages. So just wondering if this log forwading would cause those mqrc host not available errors at the client.

"host not available" is usually a network issue, or a resource shortage issue on the host. The "log forward" activity may be another symptom of this underlying issue. Can you provide details of what was in the MQ error log?
_________________
Glenn
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 » General Discussion » Long running transaction rolled forward
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.