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 ONE Support launchpad (Login required).

Search for additional results

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