SAP Knowledge Base Article - Preview

2987210 - DB2: Error 802 occurred in job SAP_CCMS_MONI_BATCH_STARTUP_DP

Symptom

Job SAP_CCMS_MONI_BATCH_STARTUP_DP fails with dump.

Dump file:

-----------------------------------------------------------


Runtime Errors         DBIF_DSQL2_SQL_ERROR

Date and Time          2020/09/08 09:18:52
-------------------------------------------------------------------------
|Short text                                                              
|    An SQL error occurred when executing Native SQL.                    
-------------------------------------------------------------------------
|What happened?                                                          
|    The error 802 occurred in the current database connection "DEFAULT".
How to correct the error                                                       
    Database error text........: "[IBM][CLI Driver][DB2] EXCEPTION ERROR FIXED 
     POINT OVERFLOW HAS OCCURRED DURING ADDITION OPERATION ON INTEGER DATA,    
     POSITION 6"                                                               
    Database error code........: 802                                           
    Triggering SQL statement...: "FETCH NEXT "                                 
    Internal call code.........: "[DBDS/NEW DSQL]"      
<snipped>
|TS_SPACE_LIST-DBNAME 
| U040ABCD
| 53335454
| 50408568

|TS_SPACE_LIST-TSNAME
| ZDB1234
| 54433332
| A4233570

-----------------------------------------------------------------        


Read more...

Environment

SAP running on IBM Db2 for z/OS

Keywords

802, DBIF_DSQL2_SQL_ERROR, RSDB2_COLLECT_DAILY, SAP_CCMS_MONI_BATCH_STARTUP_DP , KBA , BC-DB-DB2-CCM , DB2 for z/OS - CCM/Database monitors , BC-DB-DB2 , DB2 for z/OS , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.