Re: MSGQ cleanup

1 - One can easily run the sql statement provided, prior to adding the
qcmdexc scalar function, and see if they want to add further where clauses
to omit certain message queues and/or libraries. I fail to see what the
table brings to the game.
2 - The qcmdexc scalar function was what I was thinking also. Adding that
is child's play. Fixing the msgkey is slightly trickier.
3 - Don was clearing all messages in the message queues no matter what
their age.

On Wed, Jul 26, 2023 at 10:40 AM Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

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?

--
--buck

http://wiki.midrange.com
Your updates make it better!


--
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.