Re: MSGQ cleanup

You could make a table off of this:
select
MESSAGE_QUEUE_LIBRARY,
MESSAGE_QUEUE_NAME,
*max*(MESSAGE_TIMESTAMP) as oldest_message_in_queue
from QSYS2.MESSAGE_QUEUE_INFO
where
message_timestamp < *current timestamp* - *30* *days*
group by message_queue_library, message_queue_name
order by message_queue_library, message_queue_name
;

Or, if you just want it by library:
select
MESSAGE_QUEUE_LIBRARY,

*-- MESSAGE_QUEUE_NAME,**max*(MESSAGE_TIMESTAMP) as oldest_message_in_queue
from QSYS2.MESSAGE_QUEUE_INFO
where
message_timestamp < *current timestamp* - *30* *days*
group by message_queue_library
*--, message_queue_name*order by message_queue_library
*--, message_queue_name*;

On Wed, Jul 26, 2023 at 12:11 PM Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

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

to omit certain message queues and/or libraries. I fail to see what the
table brings to the game.

I recently had to add a temporary set of libraries for QA of a
particular project. Sadly, there was quite a lot of CL/SQL that had hard
coded libraries in it - these had to be hunted down and changed for the
temporary copy of the application to work as intended.

If these had been in a table, I would have had to change just the
control tables instead of digging through eleventy-seven thousand lines
of code.

I'm not intending to be prescriptive! I just thought I'd share one way
to view it.

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