Author |
Message
|
k_v_mahesh |
Posted: Mon Aug 10, 2009 6:55 am Post subject: MQ Commit and Rollback for Remote definition queue |
|
|
Newbie
Joined: 10 Aug 2009 Posts: 2
|
Hi,
Can someone clarify my basic doubts.
1. Will MQ commit and rollback work for Remote defintion queue. If no, how to handle it
2. How different will it behave in case of clustered queue.
3. we are having AS400 in our shop and when we try to issue COMMIT command in AS400 it doesn't work for MQ , The queue is defined as Remote definition queue. What does that mean.
Thanks
Magesh.K.V |
|
Back to top |
|
 |
zpat |
Posted: Mon Aug 10, 2009 7:00 am Post subject: |
|
|
 Jedi Council
Joined: 19 May 2001 Posts: 5866 Location: UK
|
Remote queue defs simply map onto a local xmit queue.
So rollback and commit work exactly the same as a local queue.
What do you mean by COMMIT command?
If you MQPUT with MQPMO_SYNCPOINT then MQCMIT or MQBACK will work.
If you MQPUT without specifiying SYNCPOINT then MQCMIT and MQBACK have no effect since the default option is NO_SYNCPOINT.
Check all MQRCs and report anything non-zero. |
|
Back to top |
|
 |
Vitor |
Posted: Mon Aug 10, 2009 8:49 am Post subject: Re: MQ Commit and Rollback for Remote definition queue |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
k_v_mahesh wrote: |
1. Will MQ commit and rollback work for Remote defintion queue. If no, how to handle it |
Yes if the message is put inside a UOW by the application.
k_v_mahesh wrote: |
2. How different will it behave in case of clustered queue. |
It doesn't behave any differently; clustering changes how the target queues are selected not how UOW is handled.
k_v_mahesh wrote: |
3. we are having AS400 in our shop and when we try to issue COMMIT command in AS400 it doesn't work for MQ , The queue is defined as Remote definition queue. What does that mean.
|
COMMIT isn't a command AFAIK (but I'm not an AS400 person). What do you mean by "it doesn't work for MQ"? Do you mean it works for other things? Are you attempting a co-ordinated 2-phase commit? If so, is the queue manager properly participating? _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
k_v_mahesh |
Posted: Tue Aug 11, 2009 4:36 am Post subject: AS400 MQ commit and Rollback |
|
|
Newbie
Joined: 10 Aug 2009 Posts: 2
|
Here is the problem,
The MQBACK and MQCOMIT is not working in AS400. Only the AS400 COMMIT and ROLLBACK is to be used as per the red books.
But when we try to issue COMMIT with in the UOW and process abends in between it rollbacks the entire UOW inspite of the fact that intermediate COMMIT has been done. |
|
Back to top |
|
 |
zpat |
Posted: Tue Aug 11, 2009 4:46 am Post subject: |
|
|
 Jedi Council
Joined: 19 May 2001 Posts: 5866 Location: UK
|
Open a PMR with IBM if their products do not appear to work as advertised. |
|
Back to top |
|
 |
|