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 IndexWebSphere Message Broker SupportHowto issue an explicit MQCMIT command inside a flow

Post new topicReply to topic
Howto issue an explicit MQCMIT command inside a flow View previous topic :: View next topic
Author Message
MrVMax
PostPosted: Wed Oct 03, 2018 4:28 am Post subject: Howto issue an explicit MQCMIT command inside a flow Reply with quote

Novice

Joined: 01 Aug 2013
Posts: 23

Hi all,

I've a requirement to issue a COMMIT on MQ inside a subflow that don't use any database but only Queues.

The ESQL command COMMIT is not supported, in a compute node the transaction property of COMMIT is supported only with the specification of an ODBC source name is there any way to issue a MQCMIT ?

If I don't find a way i must raise the uncommitted message limit of the MQ at a level very hight and I feel not very confortable in doing this.

By the way what's a reasonable limit of uncommitted messages on some QMGR I use 100.000 without any trouble but in this case I should use a lot more.
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Wed Oct 03, 2018 4:40 am Post subject: Reply with quote

Master

Joined: 17 Jul 2017
Posts: 217
Location: UK

hi...i think that is fairly straight forward to achieve, you just need to set the 'Transaction Mode' of the MQOutput node property to 'No' which takes it out of the parent transaction.

You haven't mentioned the scenario for which you want to do this, ideally it should be done for scenarios where you want to do something extra (eg:- logging the error details to a queue in the error subflow)
Back to top
View user's profile Send private message
MrVMax
PostPosted: Wed Oct 03, 2018 7:36 am Post subject: Reply with quote

Novice

Joined: 01 Aug 2013
Posts: 23

Well ... I don't need to put some messages to a queue outside a transaction, but i need to commit a transaction.

As You said set the 'Transaction Mode' of the MQOutput node property to 'No' makes the put operation outside the current transaction that stills remain uncommitted.

I've a complex flow with some subflow; the main flow use MQINPUT node to read messages from the MAINCONTROL queue that is a control queue: the messages that will be on the queue are supposed to make the flow go trough the different subflows like start the one or another subflow.

Each subflow once "started" from main reads messages from it's own input queue SUB(x)INQ using MQGET node till it reads a particular sequence of bytes (called STOP SEQUENCE) at the end of a message.

Each subflow use the message it has received dividing the message itself into different row of a db table and from each row create a new message on the SUB(x)OUTQ.

The STOP SEQUENCE makes the subflow post a control message to the MAINCONTROL queue and return to the main flow that will go trough another subflow based on the control message received.

My need is to have a MQCMIT performed after the last put on the SUB(x)OUTQ.
Back to top
View user's profile Send private message
Vitor
PostPosted: Wed Oct 03, 2018 7:50 am Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 25250
Location: Ohio, USA

MrVMax wrote:
Each subflow once "started" from main reads messages from it's own input queue SUB(x)INQ using MQGET node till it reads a particular sequence of bytes (called STOP SEQUENCE) at the end of a message.


That is a horrible design and is a great way to run an execution group out of memory.

Both this problem and your commit problem will be solved (or at least easier) if you break these subflows out as actual flows. If you need to get back into the logic of your main flow, use one of the aggregation constructs to do that.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
timber
PostPosted: Wed Oct 03, 2018 11:16 pm Post subject: Reply with quote

Sentinel

Joined: 25 Aug 2015
Posts: 855

I agree with Vitor. As a general rule, you should treat MQGet nodes like goto statements. They are sometimes the right option, but if you think you need one you should always think again.
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Thu Oct 04, 2018 12:21 am Post subject: Reply with quote

Master

Joined: 17 Jul 2017
Posts: 217
Location: UK

Agree with both the Gents that it is best to keep things simple where possible and people will thankyou for it... When coming up with designs it is always good to think about how easily it can be supported/maintained in the long run.
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportHowto issue an explicit MQCMIT command inside a flow
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.