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 » General IBM MQ Support » queue deletion problem

Post new topic  Reply to topic
 queue deletion problem « View previous topic :: View next topic » 
Author Message
rkford11
PostPosted: Sun Sep 05, 2004 2:33 pm    Post subject: queue deletion problem Reply with quote

Partisan

Joined: 06 Jun 2004
Posts: 316

i want to delete the local queue(transmission) but it gives me an error saying

Queue contains one or more messages and uncommitted put or get requests AMQ 4045

Back to top
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Sun Sep 05, 2004 3:24 pm    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

That's not really an error.

You're trying to delete a transmission queue. This queue appears to be in use, and that's what this message is telling you.

Channels are usually the things that are using transmission queues.

Also, please save the moderators some time and go delete your duplicate of this question.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
rkford11
PostPosted: Tue Sep 07, 2004 12:23 pm    Post subject: still the problem exists Reply with quote

Partisan

Joined: 06 Jun 2004
Posts: 316

jefflowrey wrote:
That's not really an error.

You're trying to delete a transmission queue. This queue appears to be in use, and that's what this message is telling you.

Channels are usually the things that are using transmission queues.

Also, please save the moderators some time and go delete your duplicate of this question.


the queue depth shows zero and no more the queue is used by channels because i have replaced it using another queue. but still i am unable to delete the queue.
Back to top
View user's profile Send private message
bower5932
PostPosted: Tue Sep 07, 2004 12:35 pm    Post subject: Reply with quote

Jedi Knight

Joined: 27 Aug 2001
Posts: 3023
Location: Dallas, TX, USA

Are you still getting the same error message when you attempt to delete the queue? Does the 'display qstatus' show any uncommitted messages?
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger
rkford11
PostPosted: Tue Sep 07, 2004 1:08 pm    Post subject: yes, it shows Reply with quote

Partisan

Joined: 06 Jun 2004
Posts: 316

bower5932 wrote:
Are you still getting the same error message when you attempt to delete the queue? Does the 'display qstatus' show any uncommitted messages?



YES, it shows uncommitted messages. how to clear them

thanks
Back to top
View user's profile Send private message
JasonE
PostPosted: Wed Sep 08, 2004 2:35 am    Post subject: Reply with quote

Grand Master

Joined: 03 Nov 2003
Posts: 1220
Location: Hursley

Is the channel which was using that xmitq still indoubt by any chance?
Back to top
View user's profile Send private message
rkford11
PostPosted: Wed Sep 08, 2004 8:12 am    Post subject: clearing uncommitted messages Reply with quote

Partisan

Joined: 06 Jun 2004
Posts: 316

JasonE wrote:
Is the channel which was using that xmitq still indoubt by any chance?


i have changed the transmission queue for the channel, but not able to delete the old transmission queue as it does have uncommitted messages. how to clear the uncommitted messages.
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Wed Sep 08, 2004 6:06 pm    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

Check queue status and specially iprocs and oprocs.
If they are all 0 run
clear ql(your transmit q)
This should clear the messages from the queue.

Enjoy
Back to top
View user's profile Send private message Send e-mail
rkford11
PostPosted: Fri Sep 10, 2004 12:03 pm    Post subject: clear queue messages Reply with quote

Partisan

Joined: 06 Jun 2004
Posts: 316

fjb_saper wrote:
Check queue status and specially iprocs and oprocs.
If they are all 0 run
clear ql(your transmit q)
This should clear the messages from the queue.

Enjoy



I have done all that, and the status shows 0 for iprocs and oprocs but there are uncommitted messages. how to delete them

thanks
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Fri Sep 10, 2004 7:28 pm    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

Code:
runmqsc <your qmgr>
clear ql(<your xmitq>)
end

Do not type the "<>" signs!
Back to top
View user's profile Send private message Send e-mail
EddieA
PostPosted: Sun Sep 12, 2004 9:50 am    Post subject: Reply with quote

Jedi

Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles

Would a stop/start of the QM either commit or "lose" the messages.

Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0
Back to top
View user's profile Send private message
JT
PostPosted: Sun Sep 12, 2004 7:11 pm    Post subject: Reply with quote

Padawan

Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.

rkford11,

For future reference, all you needed to do was resolve the channel:

Quote:
Resolve

Use the MQSC command RESOLVE CHANNEL when messages are held in-doubt by a sender or server, for example because one end of the link has terminated, and there is no prospect of it recovering. The RESOLVE CHANNEL command accepts one of two parameters: BACKOUT or COMMIT. Backout restores messages to the transmission queue, while Commit discards them.

The channel program does not try to establish a session with a partner. Instead, it determines the logical unit of work identifier (LUWID) which represents the in-doubt messages. It then issues, as requested, either:
  • BACKOUT to restore the messages to the transmission queue; or
  • COMMIT to delete the messages from the transmission queue.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » General IBM MQ Support » queue deletion problem
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.