Error CEM0644E and SQLCODE 00000000 when fetching or inserting LOB values in Datacom/AD
search cancel

Error CEM0644E and SQLCODE 00000000 when fetching or inserting LOB values in Datacom/AD

book

Article ID: 439620

calendar_today

Updated On:

Products

Datacom Datacom/AD Compliance Event Manager

Issue/Introduction

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:

 

Cause

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.

Resolution

1. Apply Required Maintenance

Ensure the following SQL PTFs (or their latest supersedes) are applied to your MUF environment:

  • LU16864 (Published 02/02/2025): Addresses XCF LOB INSERT logic and workarea length calculation. This is the primary fix for this symptom.
  • LU07502 (Published 10/18/2022)
  • LU08004 (Published 01/03/2023)
  • LU13084 (Published 04/18/2024)

2. Identify Corrupted Rows

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';


3. Implement Diagnostic Capture

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.

Additional Information

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).