Pinned topic MQ Pub/Sub Administration
I would like to perform some intellegent maintenance on this queue. Is there a utility that I can run to display what publications we are currently retaining, and perhaps some information about them, suh as when they are set to expire, when they were last accessed, etc. ? My goal would be to delete those that I probably no longer need to keep. I can see from the date/time stamp on some of the messages that some are over 1 year old. I am looking for both display and maintenance suggestions. Thanks.
R_Simons 27000167KS4 PostsACCEPTED ANSWER
Re: MQ Pub/Sub Administration2013-03-31T19:53:32Z in response to SystemAdminI suggest reading up on how MQ manages the messages on this queue.
Then manage the messages on this queue using the commands that manage topics and subscriptions. I wouldn't touch any of the messages directly.
Morag Hughson 110000EQPN140 PostsACCEPTED ANSWER
Re: MQ Pub/Sub Administration2013-04-18T16:51:16Z in response to SystemAdmin
Is there a utility that I can run to display what publications we are currently retaining
You can use the DISPLAY TPSTATUS command and look at the RETAINED(YES|NO) field. Or to see all the topics that have retained messages on them, try this command:-
DISPLAY TPSTATUS('#') WHERE(RETAINED EQ YES)
There is no information about the retained message content though, e.g. expiry of the message, it's puttime or so on.
To remove a retained message you can use the command:-
CLEAR TOPICSTR('Sports') CLRTYPE(RETAINED)Updated on 2013-04-18T16:52:06Z at 2013-04-18T16:52:06Z by Morag Hughson