Author |
Message
|
gertvangaever |
Posted: Tue Jan 06, 2004 12:21 am Post subject: how to copy mesages from dead letter queue to normal queue? |
|
|
Apprentice
Joined: 28 Apr 2003 Posts: 35 Location: Puurs, Belgium
|
Because a queue was not handled, it became full.
After it was full, messages were that were supposed to get in the queue, were sent to the dead letter queue (SYSTEM.DEAD.LETTER.QUEUE).
Now all the messages in the queue were handled, so we want to copy the messages in the dead letter queue to the original queue. But, the messages are now in a different format. Normally we copy messages from queue to queue using PQEDIT, but this doesn't strip the dead letter queue header from the message.
I've heard about a tool that exist to do this.
Doesn anyone know how I can do this??
Tnx |
|
Back to top |
|
 |
RogerLacroix |
Posted: Tue Jan 06, 2004 12:52 am Post subject: |
|
|
 Jedi Knight
Joined: 15 May 2001 Posts: 3264 Location: London, ON Canada
|
|
Back to top |
|
 |
gertvangaever |
Posted: Tue Jan 06, 2004 1:24 am Post subject: |
|
|
Apprentice
Joined: 28 Apr 2003 Posts: 35 Location: Puurs, Belgium
|
tnx...
Can I automate this in MQ Visual Edit?
(See my post in the 'Capitalware Inc.' forum) |
|
Back to top |
|
 |
oz1ccg |
Posted: Tue Jan 06, 2004 1:29 am Post subject: |
|
|
 Yatiri
Joined: 10 Feb 2002 Posts: 628 Location: Denmark
|
You can use the runmqdlq (DLQ handler) command which is supplied with WebSphere MQ.
You can specify how it shall tread messages... So you can leave messages in the queue that have been placed there because of security reason (so you don't create a security hole...)
You'll find the doc. in the system admin. guide.
I've changed our setup, so it use the IBM tool now, because it's easier to maintain.. and it offers the flexability I need.
Just my $0.02  _________________ Regards, Jørgen
Home of BlockIP2, the last free MQ Security exit ver. 3.00
Cert. on WMQ, WBIMB, SWIFT. |
|
Back to top |
|
 |
gertvangaever |
Posted: Tue Jan 06, 2004 1:35 am Post subject: |
|
|
Apprentice
Joined: 28 Apr 2003 Posts: 35 Location: Puurs, Belgium
|
I just want to copy them once...
The original queue (let's call it ORIGINAL.QUEUE) became full because it was not handled. After that all messages sent to the ORIGINAL.QUEUE were rerouted to the SYSTEM.DEAD.LETTER.QUEUE.
Now, the messages that were sent to the SDLQ should be copied to the ORIGINAL.QUEUE, so they can be handled by the program that is reading those messages.
I thought the DLQ handler is used to monitor & handle ALL messages that arrive on the DLQ... |
|
Back to top |
|
 |
Remco |
Posted: Tue Jan 06, 2004 2:19 am Post subject: |
|
|
Acolyte
Joined: 19 Mar 2002 Posts: 68 Location: Capelle aan den IJssel (Rotterdam)
|
You can use PQEDIT for this....
Use "Forward to Specific Queue" and select the option "Strip DLQ Header if found".
Real easy and quick...
Regards Remco |
|
Back to top |
|
 |
gertvangaever |
Posted: Tue Jan 06, 2004 2:26 am Post subject: |
|
|
Apprentice
Joined: 28 Apr 2003 Posts: 35 Location: Puurs, Belgium
|
[quote="Remco"]You can use PQEDIT for this....
Use "Forward to Specific Queue" and select the option "Strip DLQ Header if found".
Real easy and quick...
Regards Remco[/quote]
OK.... Tnx!
I hadn't seen this option before.
Unfortunately, I can only select 45 messages at once in PQEDIT.
I'm talking about 50.000 messages that need to be copied to the original queue, so you see we have a problem here.
It would take hours & hours to copy 45 messages each time... |
|
Back to top |
|
 |
Remco |
Posted: Tue Jan 06, 2004 2:31 am Post subject: |
|
|
Acolyte
Joined: 19 Mar 2002 Posts: 68 Location: Capelle aan den IJssel (Rotterdam)
|
Gert....
Under "Tools / Options" you can set "Max Msgs to retreive" I do'nt know the maximum by hard, but I have set this to 1000.
Then to select all retreived messages by PQEDIT you select the top block, of the first row.
Good luck |
|
Back to top |
|
 |
gertvangaever |
Posted: Tue Jan 06, 2004 2:33 am Post subject: |
|
|
Apprentice
Joined: 28 Apr 2003 Posts: 35 Location: Puurs, Belgium
|
Indeed...
Thank you VERY much!! |
|
Back to top |
|
 |
|