Re: MSGQ cleanup

On 7/26/2023 10:06 AM, Rob Berendt wrote:

Finish debugging this (fix msgkey) and pass that command to qcmdexc

One might use the QCMDEXC SQL function: https://www.ibm.com/docs/en/i/7.4?topic=services-qcmdexc-scalar-function

select
'RMVMSG MSGQ(' *concat* message_queue_library *concat* '/' *concat*
message_queue_name *concat* ') MSGKEY(' *concat* *varchar*(message_key)
*concat* ') CLEAR(*BYKEY)' as command_string,
MESSAGE_QUEUE_LIBRARY,
MESSAGE_QUEUE_NAME,
MESSAGE_TIMESTAMP,
MESSAGE_KEY
from QSYS2.MESSAGE_QUEUE_INFO
where
message_timestamp < *current timestamp* - *30* *days*
order by message_timestamp desc;

Reminder that this prunes all messages older than 30 days.
All message queues.
All libraries.
As Don notes, it might be beneficial to have the list of intended queues in a table.

On Wed, Jul 26, 2023 at 9:43 AM DEnglander--- via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Is there a way to automatically [maybe via GO CLEANUP] to remove Messages
in Message Queues that are not tied to a UserID?

We have a small amount of application message queues that do not get
automatically cleaned up. Is there a way for them to have [for example]
all messages older than 30 days to be deleted? In addition, the
application messages queues are not in QUSRSYS.

Thank you,

Doug

I don't think that a general/automated solution exists. How would one tell something like GO CLEANUP /which/ message queues need pruning, and which ought to be left alone?