Hello Safa,
The table does not look healthy. The message queues which have messages more than 500 are still available on your system? If no, you can delete them on PSQL with script that provided by IBM Support. If yes, you should make deeper investigation to find main reason of these message counts before deleting them.
------------------------------
Burak Karaduman
------------------------------
Original Message:
Sent: Fri October 22, 2021 06:22 AM
From: Safa ÜÇÜNCÜOĞLU
Subject: ActiveMQ Purge
Hi Teams,
How can I purge the ActiveMQ table?
The results I got with the "sudo -u postgres -i psql -c "select container, count(*) from monapp.activemq_msgs group by container order by count desc" co3" query:
Thanks,

------------------------------
Safa ÜÇÜNCÜOĞLU
------------------------------