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 » MQ Syncpoint

Post new topic  Reply to topic
 MQ Syncpoint « View previous topic :: View next topic » 
Author Message
yacov
PostPosted: Mon Aug 13, 2007 9:25 am    Post subject: MQ Syncpoint Reply with quote

Newbie

Joined: 27 Jul 2007
Posts: 3
Location: Israel

Hi
First of all some info about our application.
We have z/os, CICS.

We read DB2 row after row and send some bussines data from it using MQ queue lets call it bussiness queue.

Also we another queue in the same program that we use for sending messages about fatal errors in application.

Because of some considerations, in bussiness queue we work with MQPMO_SYNCPOINT option, mainly in order to make one commit in DB2 and in bussiness queue.

In the second queue that we use to write our errors we work with MQPMO_NO_SYNCPOINT option.

Now the problem:

We have a very strange error in our application.

Despite the MQPMO_SYNCPOINT option in bussiness queue, the message we put, becomes available immidiatly after the call and before the commit.(we run Intertest(debug) to be sure).

In IBM documentation they write:
Quote:
Do not specify MQPMO_NO_SYNCPOINT with MQPMO_SYNCPOINT

Do they mean our situation?

Thanks for answer.
_________________
Yacov
Back to top
View user's profile Send private message
Vitor
PostPosted: Mon Aug 13, 2007 11:29 am    Post subject: Re: MQ Syncpoint Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

yacov wrote:

In IBM documentation they write:
Quote:
Do not specify MQPMO_NO_SYNCPOINT with MQPMO_SYNCPOINT

Do they mean our situation?


Not so long as you don't mix them on the same queue.

Are you certain that both DB2 & MQ are using CICS as a transaction coordinator, and the unit of work is properly set up?
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
yacov
PostPosted: Mon Aug 13, 2007 12:12 pm    Post subject: Reply with quote

Newbie

Joined: 27 Jul 2007
Posts: 3
Location: Israel

Quote:
Are you certain that both DB2 & MQ are using CICS as a transaction coordinator, and the unit of work is properly set up?


Our sys. admin says so.

Quote:
and the unit of work is properly set up


I don't make any explicit actions to set up a unit of work.

I act within a CICS transaction. I have a loop in which I : read DB2, send MQ message, update DB2, make a commit.

Is it smth. wrong with it?
_________________
Yacov
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 » MQ Syncpoint
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.