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 » IBM MQ API Support » Transaction

Post new topic  Reply to topic
 Transaction « View previous topic :: View next topic » 
Author Message
titus
PostPosted: Mon Nov 18, 2002 2:31 pm    Post subject: Transaction Reply with quote

Novice

Joined: 14 Oct 2002
Posts: 23

Hi Guys

I am having a message flow which is doing following functionality.

It will split into different messages and put into different queues. Is it any way to rollback messages which is already placed in the queue in case of any errors occurs in between.

Thanks in advance
Back to top
View user's profile Send private message
glennire
PostPosted: Mon Nov 18, 2002 9:25 pm    Post subject: Transaction recovery Reply with quote

Newbie

Joined: 18 Nov 2002
Posts: 7
Location: USA

The broker does not do this automatically?, control the input as a unit of work?, thereby rolling back the whole input if any translation fails?
_________________
Glenn Addison
423-956-5561
glennire@gmail.com
Back to top
View user's profile Send private message Send e-mail
titus
PostPosted: Tue Nov 19, 2002 8:54 am    Post subject: Reply with quote

Novice

Joined: 14 Oct 2002
Posts: 23

Thanks Glenn Addison .

Is there is any special setting needed for this in broker level?.
Back to top
View user's profile Send private message
glennire
PostPosted: Tue Nov 19, 2002 9:28 pm    Post subject: Reply with quote

Newbie

Joined: 18 Nov 2002
Posts: 7
Location: USA

I would expect this to be the default, and only setting. Best to confirm this by causing one of the outputs to fail translation to see that the entire message then fails, withholding the successful translation from the output as well.
_________________
Glenn Addison
423-956-5561
glennire@gmail.com
Back to top
View user's profile Send private message Send e-mail
glennire
PostPosted: Wed Nov 20, 2002 4:19 am    Post subject: Broker Coordinated Transactional support Reply with quote

Newbie

Joined: 18 Nov 2002
Posts: 7
Location: USA

The default setting in the MQInput node is Yes, received under sycpoint, however this can be changed as the documentation describes below to Auto or No.

If you need to also coordinate external database updates as a unit of work then must set the Coordinated Transaction property of the message flow and the default is to not be globally coordinated. This entails additional work to make sure the queue manager is set up to support XA transactionality.

From Control Center Help
Transactional support

When you create an MQInput node, the value you set for the Transaction Mode=[Yes|Automatic|No] property defines whether messages are received under syncpoint.

If you set it to Yes (the default), the message is received under syncpoint (that is, within an MQSeries unit of work). Any messages subsequently sent by an output node in the same instance of the message flow are put under syncpoint, unless the output node has explicitly overridden this.

If you set it to Automatic, the message is received under syncpoint if the incoming message is marked persistent. Otherwise, it is not. Any message subsequently sent by an output node is put under syncpoint, as determined by the incoming persistence property, unless the output node has explicitly overridden this.

If you set it to No, the message is not received under syncpoint. Any messages subsequently sent by an output node in the flow are not put under syncpoint, unless an individual output node has specified that the message should be put under syncpoint.

(The MQOutput node is the only output node that you can configure to override this option.)
_________________
Glenn Addison
423-956-5561
glennire@gmail.com
Back to top
View user's profile Send private message Send e-mail
titus
PostPosted: Wed Nov 20, 2002 7:01 am    Post subject: Reply with quote

Novice

Joined: 14 Oct 2002
Posts: 23

Thanks Glenn

Its got fixed. Thankx for ur help
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 » IBM MQ API Support » Transaction
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.