| Author |
Message
|
| jwendorf |
 Posted: Tue Sep 11, 2007 5:40 am Post subject: Uncommitted messages on Dead letter queue |
 |
|
Acolyte
Joined: 15 May 2001
Posts: 63
Location: Madison, WI
|
We have uncommitted messages being placed on the SYSTEM.DEAD.LETTER.QUEUE. We are not able to browse the messages or clear them. Is there a way to find out where the messages are from?
dis qstatus(SYSTEM.DEAD.LETTER.QUEUE) ALL
1 : dis qstatus(SYSTEM.DEAD.LETTER.QUEUE) ALL
AMQ8450: Display queue status details.
QUEUE(SYSTEM.DEAD.LETTER.QUEUE) TYPE(QUEUE)
CURDEPTH(129) IPPROCS(0)
LGETDATE( ) LGETTIME( )
LPUTDATE( ) LPUTTIME( )
MEDIALOG(S0002684.LOG) MONQ(OFF)
MSGAGE( ) OPPROCS(1)
QTIME( , ) UNCOM(YES)
dis qstatus(SYSTEM.DEAD.LETTER.QUEUE) ALL TYPE(HANDLE)
2 : dis qstatus(SYSTEM.DEAD.LETTER.QUEUE) ALL TYPE(HANDLE)
AMQ8450: Display queue status details.
QUEUE(SYSTEM.DEAD.LETTER.QUEUE) TYPE(HANDLE)
APPLTAG(C:\mqm\bin\runmqtrm.exe) APPLTYPE(SYSTEM)
BROWSE(NO) CHANNEL( )
CONNAME( ) HSTATE(INACTIVE)
INPUT(NO) INQUIRE(YES)
OUTPUT(YES) PID(7024)
QMURID(0.3502) SET(NO)
TID(1)
URID(XA_FORMATID[00000000] XA_GTRID[] XA_BQUAL[])
URTYPE(QMGR) |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Sep 11, 2007 6:10 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
dspmqtrn
I think that's how it's spelled.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| jwendorf |
| Posted: Tue Sep 11, 2007 6:54 am Post subject: |
|
|
Acolyte
Joined: 15 May 2001
Posts: 63
Location: Madison, WI
|
Dspmqtrn shows no transactions.:
C:\Documents and Settings\JEW006>dspmqtrn -m NHQSD2QM
There are no prepared transactions. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Sep 11, 2007 6:59 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Stop all your channels, and see what happens.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Tue Sep 11, 2007 9:26 am Post subject: Re: Uncommitted messages on Dead letter queue |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
| jwendorf wrote: |
APPLTAG(C:\mqm\bin\runmqtrm.exe) APPLTYPE(SYSTEM)
|
Looks like its your trigger monitor.
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Sep 11, 2007 9:34 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The things you notice if you read the post...
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| jwendorf |
| Posted: Tue Sep 11, 2007 11:36 am Post subject: |
|
|
Acolyte
Joined: 15 May 2001
Posts: 63
Location: Madison, WI
|
| We have shutdown the trigger monitor and have not been able to clear the queue. Shouldn't we be able to? |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Tue Sep 11, 2007 6:10 pm Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
Does a q status on the DLQ now show no connections? Is PID 7024 really gone? Just cuz you ended runmqtrm doesn't me its really gone. It seems you got something flaky going on, like maybe a hung process.
Once the DLQ shows no OPROCS I would think you could browse the message(s) and delete any that are on the q.
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Sep 11, 2007 7:39 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| PeterPotkay wrote: |
| Once the DLQ shows no OPROCS I would think you could browse the message(s) and delete any that are on the q. |
Assuming that the messages are committed by stopping whatever put them on the DLQ.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Wed Sep 12, 2007 3:52 pm Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
If you stop something, I have to think either the messages will be commited or rolled back. Is there a scenario you are thinking of where truly stopping a process might leave the message uncommitted?
I suppose its possible. Ultimately its the QM that commits or rolls back the message. I suppose something could end in such a way that the QM doesn't recognize its gone, thus forever leaving the messages "in doubt". But I would think that dspmqtrn would show that.
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| Nigelg |
| Posted: Wed Sep 12, 2007 6:52 pm Post subject: |
|
|
Grand Master
Joined: 02 Aug 2004
Posts: 1046
|
dspmqtrn only shows global txns, i.e. txns involving external resource managers. Local txns, where WMQ is the only resource manager, are not listed.
_________________
MQSeries.net helps those who help themselves.. |
|
| Back to top |
|
|
|
|
