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 » Mainframe, CICS, TXSeries » Deleting messages from a queue after N days

Post new topic  Reply to topic
 Deleting messages from a queue after N days « View previous topic :: View next topic » 
Author Message
giuly020277
PostPosted: Wed Aug 20, 2008 10:12 pm    Post subject: Deleting messages from a queue after N days Reply with quote

Centurion

Joined: 07 Aug 2007
Posts: 146
Location: Florence,Italy

Goodmorning everyone,

after a good (?) italian coffee...i need your help.

How can I delete automatically messages from a queue after (for example) 10 days?
I have MQ for ZOS (v.6.0).

Can i do it directly from my MQ setting a parameters or it must be done by programs or applications?

Thank u all

Ciao

Giuliano
Back to top
View user's profile Send private message
Mr Butcher
PostPosted: Wed Aug 20, 2008 11:43 pm    Post subject: Reply with quote

Padawan

Joined: 23 May 2005
Posts: 1716

MQ will not purge messages for you except they are expired and you use the EXPRYINT of the queuemanager. But the expiry time must be set at put time in the Message Descriptor of the message.

if the messages do not carry an expiry time you need to code a utility that checks the age of the message and deletes whatever is elder then you want (e.g. by browsing the messages and then use "get message under cursor")
_________________
Regards, Butcher
Back to top
View user's profile Send private message
giuly020277
PostPosted: Thu Aug 21, 2008 12:02 am    Post subject: Reply with quote

Centurion

Joined: 07 Aug 2007
Posts: 146
Location: Florence,Italy

Thank u Mr Butcher
...
Back to top
View user's profile Send private message
RogerLacroix
PostPosted: Thu Aug 21, 2008 10:19 am    Post subject: Re: Deleting messages from a queue after N days Reply with quote

Jedi Knight

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

giuly020277 wrote:
How can I delete automatically messages from a queue after (for example) 10 days?
I have MQ for ZOS (v.6.0).

Can i do it directly from my MQ setting a parameters or it must be done by programs or applications?
Hi,

If you want a 3rd party tool then both MQ Visual Edit and MQ Batch Toolkit can do what you want.

MQ Batch Toolkit can be run directly from USS or I can give you JCL to run it directly from z/OS as a batch job. Note: The application JAR files need to be stored in the HFS file system.

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
nagpals_h
PostPosted: Fri Nov 07, 2008 7:01 am    Post subject: how to set expiry time Reply with quote

Newbie

Joined: 07 Nov 2008
Posts: 3

Hey Buther,
You told that he should put a expire time to the quee at the time of putting the quee in the quee manager.
But you didnt tell how to set that expire time.

Can you explain it, how can that be done.

Thanks,
Hemant Nagpal
Back to top
View user's profile Send private message
bruce2359
PostPosted: Fri Nov 07, 2008 7:35 am    Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.

Expiry is a field in the MQMD, and is documented in the WMQ Application Programming Reference.
_________________
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
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 » Mainframe, CICS, TXSeries » Deleting messages from a queue after N days
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.