On an Automation Engine version 12.3.8 since a month, normally the MQMEM current count is between 0 and 200, but suddenly is count spiked to 4.166, and increases with 100 new records every hour.
There is no performance issues noticed.
After investigation, with the help of this query to detect the orphan records in MQMEM:
SELECT MQMEM_PK, MQMEM_SYSTEM, MQMEM_TITLE, MQMEM_MQSET
FROM MQMEM
WHERE MQMEM_PK NOT IN (
SELECT MQMEM_PK
FROM MQMEM, EH
WHERE SUBSTR(MQMEM_TITLE, 36, 7) = 'AH_IDNR'
AND EH_AH_IDNR = SUBSTR(MQMEM_TITLE, 44, 10)
);
if was found that the records were caused by JOBF from one specific client that had been running for years and had not been modified for a long time.
After disabling the impacted JOBF jobs, the MQMEM records stopped growing which confirmed this lead.
Automation Engine Release : 12.3.x
Agents Version: 12.3.9
Context: JOBF being launched on Agents 12.3.9 were generating orphan records on MQMEM table
Defect on Agents 12.3.9 related to JOBF
After upgrading all the Agents 12.3.9 to 12.3.9 HF1 the MQMEM count decreased immediately, problem solved.