The CEMMON task took a dump and terminated with CMGR644E,CEM Change Monitor SQL ERROR SQLCODE: FFFFFC64 SQLERRM: 0001.0100.00F30805. What causes this?

Document ID : KB000047679
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:  

The CEMMON task took a dump and terminated with CMGR644E,CEM Change Monitor SQL ERROR SQLCODE: FFFFFC64 SQLERRM: 0001.0100.00F30805. What causes this?

Answer:  

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.