| Author |
Message
|
| ET |
 Posted: Wed Jun 16, 2010 1:14 am Post subject: Unable to Delete Queue due to UNCOM= Yes |
 |
|
Newbie
Joined: 15 Jun 2010
Posts: 4
|
Hi ,
I'm unable a delete a transmission Queue which is obsolete. I tried to check the connections to Queue but nothing appers. Queue has uncom message because of it I'm unable to delete it.
________________________________________________
dis qs(MQP1) uncom
20 : dis qs(MQP1) uncom
AMQ8450: Display queue status details.
QUEUE(MQP1) TYPE(QUEUE)
CURDEPTH(0) UNCOM(YES)
dis qs(MQP1) type(handle)
30 : dis qs(MQP1) type(handle)
AMQ8565: Queue Status not found.
dis ql(MQP1) Curdepth
22 : dis ql(MQP1) Curdepth
AMQ8409: Display Queue details.
QUEUE(MQP1) TYPE(QLOCAL)
CURDEPTH(0)
delete ql(MQP1) purge
21 : delete ql(MQP1) purge
AMQ8143: WebSphere MQ queue not empty.
_____________________________________________________
Can anyone help me to resolve it. These defs need to removed. |
|
| Back to top |
|
 |
| Vitor |
| Posted: Wed Jun 16, 2010 5:02 am Post subject: Re: Unable to Delete Queue due to UNCOM= Yes |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| ET wrote: |
AMQ8143: WebSphere MQ queue not empty.
|
From the documentation:
| Quote: |
AMQ8143: WebSphere MQ queue not empty.
Severity:
40 : Stop Error
Explanation:
The queue <insert_5> specified in <insert_2> is not empty or contains uncommitted updates.
Response:
Commit or roll back any uncommitted updates. If the command is DELETE QLOCAL, use the CLEAR QLOCAL command to clear the messages from the queue. Then try the command again.
|
  
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| ET |
| Posted: Wed Jun 16, 2010 5:42 am Post subject: |
|
|
Newbie
Joined: 15 Jun 2010
Posts: 4
|
Hi Viktor,
Thanks for the response, but there is no indoubt transaction to the Qmanager and there is no handles to the Queue. Depth as mention before is Zero and has one uncommited message. Not sure how to remove or commit the message to remove the Queue. Is there a way to commit it since I'm unable to see indoubt transaction.
--------------------------------------------------------------------------
C:\Documents and Settings\TT>dspmqtrn -e -i -m WQM1
There are no prepared transactions.
-------------------------------------------------------------------------- |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jun 16, 2010 5:57 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| ET wrote: |
| Not sure how to remove or commit the message to remove the Queue. |
And you can't use the clear command as specified in the documentation (which I kindly posted) because.......?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| ET |
| Posted: Wed Jun 16, 2010 6:11 am Post subject: |
|
|
Newbie
Joined: 15 Jun 2010
Posts: 4
|
Hi Vitor,
I tried using the Clear commnd before itself ..it didn't work.
------------------------------------------------------
clear ql(MQP1)
12 : clear ql(MQP1)
AMQ8143: WebSphere MQ queue not empty.
dis qs(MQP1) uncom
13 : dis qs(MQP1) uncom
AMQ8450: Display queue status details.
QUEUE(MQP1) TYPE(QUEUE)
CURDEPTH(0) UNCOM(YES)
------------------------------------------------------- |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jun 16, 2010 6:55 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
The obvious remedies are to bounce the queue manager (good for non-persistent messages) and the IH03 support pac
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| gbaddeley |
| Posted: Wed Jun 16, 2010 3:10 pm Post subject: |
|
|
Jedi
Joined: 25 Mar 2003
Posts: 2494
Location: Melbourne, Australia
|
Try putting a message to the queue and then getting it (eg. using amqsput & amqsget). Try bouncing the queue manager. It looks like the queue is in an inconsistent state. MQ may repair the state of the queue in the right circumstances.
_________________
Glenn |
|
| Back to top |
|
|
| ET |
| Posted: Thu Jun 17, 2010 2:56 am Post subject: |
|
|
Newbie
Joined: 15 Jun 2010
Posts: 4
|
Thanks Vitor and gbaddeley
Using sample API's I was able to put and get test message but not able to delete it. During the weekend maintenance I will recycle the qmgr and delete the queue. some thing weird with the queue! |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Jun 17, 2010 4:31 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Jun 17, 2010 6:11 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
http://publib.boulder.ibm.com/infocenter/wmqv7/v7r0/index.jsp?topic=/com.ibm.mq.amqzag.doc/fa15890_.htm
I'm not quite sure who gets this, but someone else in this thread should have at least mentioned the above...  |
I had discounted that as the OP wasn't getting anything out of dspmqtrn
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Thu Jun 17, 2010 7:19 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9396
Location: US: west coast, almost. Otherwise, enroute.
|
There is another method:
1) navigate down the filepath to the .../queues/MPQ1
2) inside the MPQ1 directory is a file named q
3) with a DOS/UNIX command, delete the q file
This will damage the MPQ1 queue object.
Now, you should be able to delete it with the delete ql(MPQ1) command
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| aditya.aggarwal |
| Posted: Thu Jun 17, 2010 7:59 am Post subject: |
|
|
Master
Joined: 13 Jan 2009
Posts: 252
|
| Was there any FDC in your system with error description "disk full" with errno 0 for this queue? |
|
| Back to top |
|
|
| JosephGramig |
| Posted: Fri Jun 18, 2010 10:06 am Post subject: |
|
|
Grand Master
Joined: 09 Feb 2006
Posts: 1231
Location: Gold Coast of Florida, USA
|
bruce2359,
Do you subscribe to the notion, "Violence is the way!"?
Reminds me of the two kids in "Talladega Nights" running around screaming "Anarchy! Anarchy!". |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Jun 18, 2010 11:04 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| bruce2359 wrote: |
There is another method:
1) navigate down the filepath to the .../queues/MPQ1
2) inside the MPQ1 directory is a file named q
3) with a DOS/UNIX command, delete the q file
This will damage the MPQ1 queue object.
Now, you should be able to delete it with the delete ql(MPQ1) command |
Subtle.... 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Fri Jun 18, 2010 11:15 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9396
Location: US: west coast, almost. Otherwise, enroute.
|
| Quote: |
| Do you subscribe to the notion, "Violence is the way!"? |
No. It's more like "occasional violence is a way." This is referred to as "needful violence."
Sometimes a hammer is what you need.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
|
|
