Error Message :
When a system stops and you see “Shrink of MQ tables causes system stop” it is not the actual cause of the error.
Shrinking of the MQ tables is not the root cause of the system stop rather it is a “SELECT FOR UPDATE SKIP LOCKED” on the MQ tables.
ORDER BY MQWP_Priority, MQWP_SchedTime, MQWP_PK FOR UPDATE SKIP LOCKED;
The shrink was blocked by a select and this led to other sessions querying the MQ table also being locked.
In order to resolve the issue, install the attached procedure. Upon testing the procedure, remove it from UC_REORG_NEW to UC_REORG.
NOTE: Contact Automic Support before installing the procedure to ensure that the attached file is not outdated.