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
