Andreas_Sprosec_7439

Shrink of MQ tables causes system stop

Discussion created by Andreas_Sprosec_7439 on Sep 14, 2016
Latest reply on May 24, 2017 by Josef_Kaiser-Muehlecker_99
Unfortunately  "Shrink of MQ tables causes system stop" is a wrong fault indication.

It looks that shrinking of the MQ tables is the root cause of system stop but the RCA is a "SELECT FOR UPDATE SKIP LOCKED" on MQ tables.

e.g.: SELECT MQWP.*,ROWID FROM MQWP WHERE MQWP_SchedTime<=:A0001 ORDER BY MQWP_Priority, MQWP_SchedTime, MQWP_PK FOR UPDATE SKIP LOCKED;

The shrink was blocked by a select and the consequence is that other sessions which are querying the MQ table are also locked.

To fix this issue you can install the attached procedure. After testing you have to remove the procedure from UC_REORG_NEW to UC_REORG.

Note: This is related to an Oracle Database!

Attachments

Outcomes