| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| Messageset lost! |
« View previous topic :: View next topic » |
| Author |
Message
|
| lancia |
 Posted: Tue Sep 30, 2008 4:47 am Post subject: |
 |
|
Novice
Joined: 25 Sep 2008
Posts: 10
|
| mqjeff wrote: |
As I said earlier, you probably need to do very careful manual edits on the MRM database. |
How can i accomplish this?
Wich tools can be used?
Thank you very much. |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Sep 30, 2008 5:02 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Whatever tools your database supplies, or whatever tools you have that can talk to a database. |
|
| Back to top |
|
|
| lancia |
| Posted: Thu Oct 02, 2008 3:29 am Post subject: MRM database |
|
|
Novice
Joined: 25 Sep 2008
Posts: 10
|
Hello
I've looked in all tables of the MQSIMRDB and MQSICMDB once again with no result, it is clear that the ghost messageset is not defined there, it must be another file in wich messageset are stored before they go to the PROJECT table of the MQSIMRDB. Sadly there's absolutely no literature about it.  |
|
| Back to top |
|
|
| lancia |
| Posted: Thu Oct 02, 2008 2:16 pm Post subject: How can be read an message in a queue safely? |
|
|
Novice
Joined: 25 Sep 2008
Posts: 10
|
Hello
I'm on the suspcion that the missing messageset is stored in this queue:
SYSTEM.CLUSTER.REPOSITORY.QUEUE
There's only one message there, i've checked all the tables on the two databases plus all the files on the MRM folder (this is windows) and there's no trace of messageset, so it must be there, awaiting for it's validation.
This command let's you display the content of a queue:
amqsbcg QueueName QManager
But it does not parse it in a human readable format.
How can i retrieve the content in that queue without emtying out it?
Given the case it's what i'm looking for, how on earth can i erase it?
Whith the use of the mqget command?
Thank you all very much for your help |
|
| Back to top |
|
|
| gbaddeley |
| Posted: Thu Oct 02, 2008 3:01 pm Post subject: Re: How can be read an message in a queue safely? |
|
|
Jedi Knight
Joined: 25 Mar 2003
Posts: 2538
Location: Melbourne, Australia
|
| lancia wrote: |
Hello
I'm on the suspcion that the missing messageset is stored in this queue:
SYSTEM.CLUSTER.REPOSITORY.QUEUE
There's only one message there, i've checked all the tables on the two databases plus all the files on the MRM folder (this is windows) and there's no trace of messageset, so it must be there, awaiting for it's validation.
This command let's you display the content of a queue:
amqsbcg QueueName QManager
But it does not parse it in a human readable format.
How can i retrieve the content in that queue without emtying out it?
Given the case it's what i'm looking for, how on earth can i erase it?
Whith the use of the mqget command?
Thank you all very much for your help |
You'd be wrong because that queue is used internally by MQ to maintiain the local state of knowledge about queue managers, queues, and channels in the MQ cluster.
If the MQ messages are perisistent and haven't expired, they have either:
- been consumed by an application
- on an application queue
- on a transmission queue (including system.cluster.transmit.queue)
- on a dead letter queue.
_________________
Glenn |
|
| Back to top |
|
|
|
|
|
|
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
|
|
|
|
