Re: MSGQ cleanup

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

Finish debugging this (fix msgkey) and pass that command to qcmdexc
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;

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
>
>
>
> "CONFIDENTIALITY NOTICE:  This e-mail transmission (and/or the attachments
> accompanying it) contain confidential information belonging to the sender.
> The information is intended only for the use of the intended recipient.  If
> you are not the intended recipient, you are hereby notified that any
> disclosure, copying, distribution or the taking of any action in reliance
> on the contents of the information is strictly prohibited.  Any
> unauthorized interception of this transmission is illegal under the law.
> If you have received this transmission in error, please promptly notify the
> sender by reply e-mail, and then destroy all copies of the transmission."
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.