| Author | 
		  Message
		 | 
		
		  | jonasb | 
		  
		    
			  
				 Posted: Mon Feb 06, 2012 7:19 am    Post subject: Incorrect value from CURDEPTH | 
				     | 
			   
			 
		   | 
		
		
		   Apprentice
 
 Joined: 20 Dec 2006 Posts: 49 Location: Sweden 
  | 
		  
		    
			  
				Hi,
 
 
On our Dead letter queue, curdepth reports depth=2, but if you read or browse the queue there is not message on the queue? 
 
 
Can someone help me understand this? Also, if there is a solution to "sync" the queue it would be helpful. 
 
 
We are running on AIX 6100-06, and MQ 7.1.0.3. 
 
 
curdepth command: 
 
echo "display ql(dead_letter_queue) curdepth" | runmqsc QMANAGERX
  Last edited by jonasb on Mon Feb 06, 2012 7:45 am; edited 2 times in total | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | Vitor | 
		  
		    
			  
				 Posted: Mon Feb 06, 2012 7:20 am    Post subject: Re: Incorrect value from CURDEPTH | 
				     | 
			   
			 
		   | 
		
		
		    Grand High Poobah
 
 Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA 
  | 
		  
		    
			  
				
   
	| contact admin wrote: | 
   
  
	| Can someone help me understand this? | 
   
 
 
 
The messages are uncommitted, i.e. the application which put them there did it inside a unit of work & didn't issue a commit.
 
 
This is 1 good reason why applications shouldn't use the queue manager's dead letter queue. _________________ Honesty is the best policy.
 
Insanity is the best defence. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | exerk | 
		  
		    
			  
				 Posted: Mon Feb 06, 2012 7:23 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Council
 
 Joined: 02 Nov 2006 Posts: 6339
  
  | 
		  
		    
			  
				Uncommitted messages count towards depth but are unavailable to browse or get. What is the UNCOM count, if any?
 
 
EDIT: And you're back-level on maintenance. _________________ It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | jonasb | 
		  
		    
			  
				 Posted: Mon Feb 06, 2012 7:37 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Apprentice
 
 Joined: 20 Dec 2006 Posts: 49 Location: Sweden 
  | 
		  
		    
			  
				Thanks for the quick response!
 
 
The command.. 
 
   
	| Code: | 
   
  
	
 
echo "display qstatus(dead_letter_queue) UNCOM" | runmqsc QMANAGERX
 
 | 
   
 
 
 
..does indicated uncommitted messages: 
 
 
   
	| Code: | 
   
  
	
 
AMQ8450: Display queue status details.
 
   QUEUE(dead_letter_queue)                TYPE(QUEUE)
 
   CURDEPTH(2)                             UNCOM(YES)
 
 | 
   
 
 
 
 
The messages has been there for days, what (good) options do I have for cleaning up? _________________ contact admin | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | Vitor | 
		  
		    
			  
				 Posted: Mon Feb 06, 2012 7:46 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Grand High Poobah
 
 Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA 
  | 
		  
		    
			  
				
   
	| contact admin wrote: | 
   
  
	| The messages has been there for days, what (good) options do I have for cleaning up? | 
   
 
 
 
Your first action should be the steps given here. There is (presumably) a reason these messages were dead lettered and it might be a good idea to find out why before flushing them.
 
 
Also your best good option for clearing off is to get whatever put them to commit them & clear them off in the traditional manner. If they've been there for the length of time you indicate, that's sounding like it's not going to happen. _________________ Honesty is the best policy.
 
Insanity is the best defence. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | jonasb | 
		  
		    
			  
				 Posted: Mon Feb 06, 2012 8:01 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Apprentice
 
 Joined: 20 Dec 2006 Posts: 49 Location: Sweden 
  | 
		  
		    
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |