CEMMON task terminated with "CMGR644E,CEM Change Monitor SQL ERROR SQLCODE: FFFFFC64 SQLERRM: 0001.0100.00F30805".

Products

• Compliance Event Manager

Issue/Introduction

The Compliance Event Manager CEMMON task took a dump and terminated with error message, "CMGR644E,CEM Change Monitor SQL ERROR SQLCODE: FFFFFC64 SQLERRM: 0001.0100.00F30805".  

Resolution

The reason code included in the error message CEM0644E indicates the DB2 subsystem has terminated or is in the process of 

terminating, and without the DB2 backend the monitor cannot continue to run. Here is the IBM definition of the reason code:  

00F30805  

Explanation 

The caller's connection with DB2 has been terminated, because the DB2 

subsystem has terminated or is in the process of terminating abnormally.  

System action 

The request may have been processed or aborted.  

User response 

The requester may identify to DB2 when it becomes operational again.  

As of now CEM processing does not have the type of recovery where it can either automatically switch to another sub system 

in a DB2 sharing group or recognize the restart of DB2 and auto connect. That capability is in the planning stages for future 

enhancements to CEM, for now sites should just restart the CEM monitor after DB2 is once again available and it should be 

successful.

 

Additional Information

CR24 - EKB 9/27/24