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 » Websphere MQ Not Empty - UnCommitted transactions in MQ

Post new topic  Reply to topic
 Websphere MQ Not Empty - UnCommitted transactions in MQ « View previous topic :: View next topic » 
Author Message
hariprashanth
PostPosted: Wed Oct 01, 2008 1:02 am    Post subject: Websphere MQ Not Empty - UnCommitted transactions in MQ Reply with quote

Newbie

Joined: 30 Sep 2008
Posts: 8
Hi all,

I am facing some severe issues with MQ which is creating show stopper issues. I am using MQ for putting and getting messages which is in a Transaction Scope enlisted with JOTM's Transaction Manager along with an Oracle Database XA Resource. When the process is started messages are flowing in and out correctly.

But when i stop the process inbetween when messages are flowing. Some transactions are left uncommitted in the MQ. When i try to clear the Queue i get the followin error in some of the MQ's.

AMQ:8143:WebSphere MQ Not Empty

I tried to get the transactions which are uncommitted using the dspmqtrn.

I got the transaction numbers with the above command.

I backed out the transactions with the command rsvmqtrn.

Some Queues got resolved with the above process.

But the problem now is, some of the MQ's still remains in "Websphere MQ Not Empty" status when i try to clear the Queue

dspmqtrn is not returning and Uncommitted transaction Numbers. Some messages are there in the Queue. I can see in the CURDEPTH attribute. I even tried writing a sample GET program to get out the messages. But its returning a No Message Exception (2033) even if CURDEPTH is showing some value > 0

Please help me come out of this issue.
Back to top
View user's profile Send private message Send e-mail
Tibor
PostPosted: Wed Oct 01, 2008 1:33 am    Post subject: Re: Websphere MQ Not Empty - UnCommitted transactions in MQ Reply with quote

Grand Master

Joined: 20 May 2001
Posts: 1033
Location: Hungary
hariprashanth wrote:
When i try to clear the Queue i get the followin error in some of the MQ's.

AMQ:8143:WebSphere MQ Not Empty


It's very strange because I got this message only when deleting a non-empty queue (DELETE QLOCAL)
Back to top
View user's profile Send private message
hariprashanth
PostPosted: Wed Oct 01, 2008 2:08 am    Post subject: Reply with quote

Newbie

Joined: 30 Sep 2008
Posts: 8
yes. its strange. Whenever i stop the process inbetween when transactions are in progress. Its acceptable that some transactions may remain uncommitted when system exit happens. But why does this "Websphere MQ Not Empty" message comes even when dspmqtrn is not returning any uncommitted transactions?
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » IBM MQ API Support » Websphere MQ Not Empty - UnCommitted transactions in MQ
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.