| 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 2009Posts: 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 2001Posts: 5867
 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 2005Posts: 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 2009Posts: 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 2001Posts: 5867
 Location: UK
 
 | 
			  
				| Open a PMR with IBM if their products do not appear to work as advertised. |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  |  |