| Author | 
		  Message
		 | 
		
		  | hkhan12 | 
		  
		    
			  
				 Posted: Tue Apr 17, 2007 11:20 am    Post subject: Deleting Uncommitted Messages | 
				     | 
			   
			 
		   | 
		
		
		   Voyager
 
 Joined: 08 Aug 2002 Posts: 98
  
  | 
		  
		    
			  
				Hello MQ Experts, 
 
 
I have a local queue and I was trying delete the queue but its the queue in not empty. 
 
 
I did a queue status and here is the result: 
 
 
DIS QSTATUS(EMBDIT2) 
 
6 : DIS QSTATUS(EMBDIT2) 
 
AMQ8450: Display queue status details. 
 
QUEUE(EMBDIT2) IPPROCS(0) 
 
OPPROCS(0) CURDEPTH(0) 
 
UNCOM(YES) 
 
 
I recycled my queue manager, I tried dspmqtrn, its says no transactions. 
 
 
Can somebody help me here please. Any input would be difinitely help me and highly appreciated. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | tleichen | 
		  
		    
			  
				 Posted: Tue Apr 17, 2007 1:05 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Yatiri
 
 Joined: 11 Apr 2005 Posts: 663 Location: Center of the USA 
  | 
		  
		    
			  
				What does this have to do with "Deleting Uncommitted Messages"?    _________________ IBM Certified MQSeries Specialist
 
IBM Certified MQSeries Developer | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | jefflowrey | 
		  
		    
			  
				 Posted: Tue Apr 17, 2007 1:08 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Grand Poobah
 
 Joined: 16 Oct 2002 Posts: 19981
  
  | 
		  
		    
			  
				
   
	| tleichen wrote: | 
   
  
	What does this have to do with "Deleting Uncommitted Messages"?    | 
   
 
 
 
   
	| hkhan12 wrote: | 
   
  
	
 
UNCOM(YES)  | 
   
 
 _________________ I am *not* the model of the modern major general. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | hkhan12 | 
		  
		    
			  
				 Posted: Tue Apr 17, 2007 1:39 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Voyager
 
 Joined: 08 Aug 2002 Posts: 98
  
  | 
		  
		    
			  
				
   
	| tleichen wrote: | 
   
  
	What does this have to do with "Deleting Uncommitted Messages"?    | 
   
 
 
 
What do you mean? I was trying to delete a local queue but it is saying the queue is not empty that means there are some uncommitted messages in the queue since some applications are still keep this queue open. 
 
 
though its not showing the current queue depth, but it is showing 
 
UNCOM(YES)
 
 
If I'm missing something  here, please point it to me but please do not  answer vaguely. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | tleichen | 
		  
		    
			  
				 Posted: Sun Apr 22, 2007 3:38 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Yatiri
 
 Joined: 11 Apr 2005 Posts: 663 Location: Center of the USA 
  | 
		  
		    
			  
				The way I see it, you can either:
 
 
Have the application(s) that have uncommitted messages commit them.
 
 
Forcefully terminate said applications, thus maybe losing the messages
 
 
or
 
 
Restart the queue manager and make sure no apps are started before you delete the queue.  But, if some apps need it, why are you deleting it?    _________________ IBM Certified MQSeries Specialist
 
IBM Certified MQSeries Developer | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |