Thank you everyone for your responses. Here is what I tried, to no avail: Stopped the Channel Enable GET on xmitq tried to clear them thru Patrol. Patrol gave me a message...something about trying to close a perm dyn queue :-| Then I went into MQSC and tried to clear the msgs and got the following error:
clear qlocal(OS4MQSP1) AMQ8143: WebSphere MQ queue not empty. The queue at that time was not in use. And the channel was NOT indoubt. So I gave up....I resized the queues on the iSeries to allow the msgs to go to the remote queue manager and then was able to clear them there. Regards, Gina -----Original Message----- From: MQSeries List [mailto:[EMAIL PROTECTED] Behalf Of Pavel Tolkachev Sent: Wednesday, May 26, 2004 1:16 PM To: [EMAIL PROTECTED] Subject: Re: Problem with clearing a queue Hello Gina, I had this problem just today -- looks like it is contagious :-) Stop channels, enable 'get' on the queue and remove all messages. Then restart channels (I also had to reset sender although I am not sure if I had to use ALTER QLOCAL(xmit.queue.name) GET(enabled) FORCE. And you cannot use amqsget because it does not remove truncated messages. I have a program of my own that does it (accepting truncated messages). I am not sure if this is "the right way"; anyone who knows the recommended way of solving the problem, please let me know (my problem was that the user had to change a downstream queue manager to another one and they made the previous queue manager inavailable first thing :-). So some messages got stuck in the transmission queue with the old XMITQ header). Hope this will help, Pavel [EMAIL PROTECTED] .NET To: [EMAIL PROTECTED] Sent by: MQSeries cc: List Subject: Re: Problem with clearing a queue <[EMAIL PROTECTED] n.AC.AT> 05/26/2004 11:17 AM Please respond to MQSeries List "How about using 'rsvmqtrn' to either commit or back out the UoW?? " ---I dont think you can use "rsvmqtrn" as it is used only if you have a transaction that is indoubt when you are doing a 2-phase commit. "clear qlocal(OS4MQSP1) AMQ8143: WebSphere MQ queue not empty. Has any seen this? Any recommendations?" ---Gina, as already mentioned, there seems to be a UOW that is indoubt. Did you get any error messages in your error log. Usually you would see something like, "the last batch of messages was not sent". And this happens because of the message sequence number. Usually again, with large messages. Since the MCA has to send all of them within a UOW. By the way, did the Channel go down by itself or was it stopped. Did it at any point in time go into retry state. Any Fd's on either system. Cheers Kumar Ken Woloschuk <[EMAIL PROTECTED]> Sent by: MQSeries List <[EMAIL PROTECTED]> 05/25/2004 09:08 AM Please respond to woloschuk To: [EMAIL PROTECTED] cc: Subject: Re: Problem with clearing a queue How about using 'rsvmqtrn' to either commit or back out the UoW?? -----Original Message----- From: MQSeries List [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 05:26 To: [EMAIL PROTECTED] Subject: Re: Problem with clearing a queue Gina, Sounds like the channel is "Indoubt". Resolve the channel with the BACKOUT option. Then see if you can clear the queue. If this works i think you will need to reset the sequence number before starting the channel back up. Gina McCarthy <[EMAIL PROTECTED] To: [EMAIL PROTECTED] .COM> cc: Sent by: MQSeries Subject: Re: Problem with clearing a queue List <[EMAIL PROTECTED] n.AC.AT> 05/25/2004 07:13 AM Please respond to gimccarthy Bill, Thanks for your response. The reason why I didn't get the 'in use' message is because the channel is down. There are no ipprocs/opprocs. The get/put are both enabled. I even went as far as to change the usage to normal...nothing is working. Regards, Gina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, May 24, 2004 5:36 PM To: [EMAIL PROTECTED] Subject: Re: Problem with clearing a queue Well, for one thing, if the channel is still running, it has the transmit queue open for exclusive use. That means no other application can open the queue for input (to get messages). If the channel is stopped, It would have disabled gets on the queue when it went down, which has the same effect. You would have to re-enable gets on the queue before you can clear it. That said about xmit queues, I am surprised at the error, I would expect something different, like "queue in use" or something similar. Anyway, you may want to try ensuring the channel is down (stopped) and then use MQSC commands to re-enable the get attribute on the queue and see if that helps. Bill Anderson SITA Atlanta, GA Standard Messaging Engineering WebSphere MQ Service Owner 770-303-3503 (office) 404-915-3190 (cell) [EMAIL PROTECTED] http://www.mconnect.aero/ Gina McCarthy <[EMAIL PROTECTED] To: [EMAIL PROTECTED] .com> cc: Sent by: MQSeries Subject: Problem with clearing a queue List <[EMAIL PROTECTED] N.AC.AT> 05/24/2004 04:43 PM Please respond to gimccarthy I have a queue on AIX 5.3 that has 25000 msgs in it. It is a transmit queue. One of the messages is 2.5M...too big. I cannot delete that message nor can I clear the queue. I get the following error: clear qlocal(OS4MQSP1) AMQ8143: WebSphere MQ queue not empty. Has any seen this? Any recommendations? Regards, Gina McCarthy Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive This communication is for informational purposes only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of J.P. Morgan Chase & Co., its subsidiaries and affiliates. Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive
