ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » General Discussion » how to copy mesages from dead letter queue to normal queue?

Post new topic  Reply to topic
 how to copy mesages from dead letter queue to normal queue? « View previous topic :: View next topic » 
Author Message
gertvangaever
PostPosted: Tue Jan 06, 2004 12:21 am    Post subject: how to copy mesages from dead letter queue to normal queue? Reply with quote

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
View user's profile Send private message
RogerLacroix
PostPosted: Tue Jan 06, 2004 12:52 am    Post subject: Reply with quote

Jedi Knight

Joined: 15 May 2001
Posts: 3264
Location: London, ON Canada

Hi,

You could use MQ Visual Edit. It will copy the messages from one queue to another queue and it supports stripping of the dead letter header.

You can download a 30-day trial of MQ Visual Edit at:
http://www.capitalware.biz/products.html

Regards,
Roger Lacroix
Capitalware Inc.
_________________
Capitalware: Transforming tomorrow into today.
Connected to MQ!
Twitter
Back to top
View user's profile Send private message Visit poster's website
gertvangaever
PostPosted: Tue Jan 06, 2004 1:24 am    Post subject: Reply with quote

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
View user's profile Send private message
oz1ccg
PostPosted: Tue Jan 06, 2004 1:29 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger
gertvangaever
PostPosted: Tue Jan 06, 2004 1:35 am    Post subject: Reply with quote

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
View user's profile Send private message
Remco
PostPosted: Tue Jan 06, 2004 2:19 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger
gertvangaever
PostPosted: Tue Jan 06, 2004 2:26 am    Post subject: Reply with quote

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
View user's profile Send private message
Remco
PostPosted: Tue Jan 06, 2004 2:31 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger
gertvangaever
PostPosted: Tue Jan 06, 2004 2:33 am    Post subject: Reply with quote

Apprentice

Joined: 28 Apr 2003
Posts: 35
Location: Puurs, Belgium

Indeed...
Thank you VERY much!!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » General Discussion » how to copy mesages from dead letter queue to normal queue?
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.