The Compliance Event Manager (CEM) started task CEMMON abends or reports an error during SQL operations involving Large Object (LOB) columns.
Symptom: The job log displays the following error message:
CEM0644E CEM Change Monitor SQL ERROR SQLCODE: 00000000 SQLERRM:
The issue is typically caused by outdated Datacom SQL maintenance. Specifically, a defect exists where MUF may incorrectly communicate the workarea length to SQL during LOB insert operations. This is highly prevalent when using XCF for remote system communication, where the last portion of the LOB data might not be properly passed.
Ensure the following SQL PTFs (or their latest supersedes) are applied to your MUF environment:
Run the following SQL query to check if existing rows in the ZMRECORD table have been stored with incorrect LOB descriptors:
SELECT ZMCATEGORY, ZMSYSID, ZMSYSPLEXID, ZMTIMESTAMP, ZMRECSIZE
FROM CEMEQ1.ZMTBL
WHERE CAST(SUBSTR(ZMRECORD, 1, 8) AS CHAR(8) WITHOUT CONVERSION) = 'ZMRECORD';
If the problem persists after maintenance, apply Diagnostic APAR LT20430. This APAR is designed to detect a bad LOB INSERT in real-time and trigger a SQLCODE -999 dump for further analysis by Broadcom Support.
If a diagnostic dump is triggered, provide the MUF SQL SYSOUT containing the dump for SQLCODE -999 to Broadcom Support for analysis. It may indicat an issue when a LOB value is being fetched or inserted, particularly in environments using Cross-System Coupling Facility (XCF).