Symptom
Shortdump BCD_OVERFLOW is raised when trying to view backup history from T-cd:DB02 -> Backup and recovery-> Overview:
Category ABAP Programming Error
Runtime Errors BCD_OVERFLOW
ABAP Program CL_DB6_CALENDAR_TOOL==========CP
Application Component BC-DB
Overflow during an arithmetic operation (type P) in program
"CL_DB6_CALENDAR_TOOL==========CP".
System log(SM21) shows:
BY2 Database error -413 at FET
BY0 > SQL0413N Overflow occurred during numeric data type
BY0 > conversion. SQLSTATE=22003 row=1
AB0 Runtime error "BCD_OVERFLOW" occurred
AB1 > Short dump "180711 161734 bcrmispci_ISP_01 SAPSUPPORT" created.
Corresponding WP shows:
C *** ERROR in DB6Fetch[/bas/749_REL/src/dbs/db6/dbdb6.c, 4128] CON = 1 (BEGIN)
C &+ dsql_db6_array_fetch( SQLFetch ): [IBM][CLI Driver][DB2/HPUX-IA64] SQL0413N Overflow occurred during numeric data
C &+ type conversion. SQLSTATE=22003 row=1
C &+
C &+ SELECT START_TIME ,
C &+ '19000101' AS START_DATE ,
C &+ '000000' AS START_DAY_TIME ,
C &+ DBPARTITIONNUM ,
C &+ OPERATION_RUNTIME2 ,
C &+ SQLCODE ,
C &+ ' ' AS LINECOLOR ,
C &+ EID ,
C &+ END_TIME ,
C &+ '19000101' AS END_DATE ,
C &+ '000000' AS END_DAY_TIME ,
C &+ SEQNUM ,
C &+ FIRSTLOG ,
C &+ LASTLOG ,
C &+ COMMENT ,
C &+ NUM_TBSPS ,
C &+ TBSPNAMES ,
C &+ OBJECTTYPE ,
C &+ ' ' AS BU_GRANULARITY_LABEL ,
C &+ OPERATIONTYPE ,
C &+ ' ' AS BU_TYPE_LABEL ,
C &+ DEVICETYPE ,
C &+ ' ' AS DEVICETYPE_LABEL ,
C &+ LOCATION ,
C &+ ENTRY_STATUS ,
C &+ ' ' AS ENTRY_STATUS_LABEL ,
C &+ CASE
C &+ WHEN (SQ_NO_AGGR.SQLCODE) IS NULL THEN
C &+ ' '
C &+ ELSE
C &+ VARCHAR( SQLERRM( 'SQL' CHAR( ABS((SQ_NO_AGGR.SQLCODE)) ), (SQ_NO_AGGR.SQLERRMC), x'FF',
C &+ 'en_US', 1 ), 256)
C &+ END AS SQL_ERROR_TEXT2 ,
C &+ OPERATION ,
C &+ CAST( CAST( DECFLOAT( ( SELECT STRIP(STRIP(STRIP(STRIP(VARCHAR( SUBSTR(FULLREC, LENGTH(FULLREC)-10,10) ),
C &+ B, X'0A'), B, X'0D'), B, X'15'), B, X'20' )
C &+ FROM TABLE(PD_GET_DIAG_HIST( 'MAIN', 'DX', '', CAST( CAST( (SQ_NO_AGGR.END_TIME) AS T
C &+ IMESTAMP) - 2 MINUTES AS TIMESTAMP), CAST( CAST(SQ_NO_AGGR.END_TIME AS TIMESTAMP) + 2
C &+ MINUTES AS TIMESTAMP)) )
C &+ WHERE FULLREC LIKE '%sqluxLogDataStats%BM#%MC#%' FETCH FIRST 1 ROW ONLY )
C &+ ) * DECFLOAT( CASE
C &+ WHEN ( POSSTR( ( SELECT SUBSTR(FULLREC, POSITION( 'MC#', FULLREC, CODEUNITS32) )
C &+ FROM TABLE(PD_GET_DIAG_HIST( 'MAIN', 'DX', '', CAST( CAST( (SQ_NO_AGG
C &+ R.END_TIME) AS TIMESTAMP) - 2 MINUTES AS TIMESTAMP), CAST( CAST(SQ_NO
C &+ _AGGR.END_TIME AS TIMESTAMP) + 2 MINUTES AS TIMESTAMP) ) )
C &+ WHERE FULLREC LIKE '%sqluxLogDataStats%BM#%MC#%' FETCH FIRST 1 ROW ON
C &+ LY )
C &+ , 'TBytes') ) > 0 THEN 1024*1024
C &+ WHEN ( POSSTR( ( SELECT SUBSTR(FULLREC, POSITION( 'MC#', FULLREC, CODEUNITS32) )
C &+ FROM TABLE(PD_GET_DIAG_HIST( 'MAIN', 'DX', '', CAST( CAST( (SQ_NO_AGG
C &+ R.END_TIME) AS TIMESTAMP) - 2 MINUTES AS TIMESTAMP), CAST( CAST(SQ_NO
C &+ _AGGR.END_TIME AS TIMESTAMP) + 2 MINUTES AS TIMESTAMP) ) )
C &+ WHERE FULLREC LIKE '%sqluxLogDataStats%BM#%MC#%' FETCH FIRST 1 ROW ON
C &+ LY )
C &+ , 'GBytes')) > 0 THEN 1024
C &+ WHEN ( POSSTR( ( SELECT SUBSTR(FULLREC, POSITION( 'MC#', FULLREC, CODEUNITS32) )
C &+ FROM TABLE(PD_GET_DIAG_HIST( 'MAIN', 'DX', '', CAST( CAST( (SQ_NO_AGG
C &+ R.END_TIME) AS TIMESTAMP) - 2 MINUTES AS TIMESTAMP), CAST( CAST(SQ_NO
C &+ _AGGR.END_TIME AS TIMESTAMP) + 2 MINUTES AS TIMESTAMP) ) )
C &+ WHERE FULLREC LIKE '%sqluxLogDataStats%BM#%MC#%' FETCH FIRST 1 ROW ON
C &+ LY )
C &+ , 'MBytes')) > 0 THEN 1
C &+ WHEN ( POSSTR( ( SELECT SUBSTR(FULLREC, POSITION( 'MC#', FULLREC, CODEUNITS32) )
C &+ FROM TABLE(PD_GET_DIAG_HIST( 'MAIN', 'DX', '', CAST( CAST( (SQ_NO_AGG
C &+ R.END_TIME) AS TIMESTAMP) - 2 MINUTES AS TIMESTAMP), CAST( CAST(SQ_NO
C &+ _AGGR.END_TIME AS TIMESTAMP) + 2 MINUTES AS TIMESTAMP) ) )
C &+ WHERE FULLREC LIKE '%sqluxLogDataStats%BM#%MC#%' FETCH FIRST 1 ROW ON
C &+ LY )
C &+ , 'kBytes')) > 0 THEN 1.0/1024.0
C &+ WHEN ( POSSTR( ( SELECT SUBSTR(FULLREC, POSITION( 'MC#', FULLREC, CODEUNITS32) )
C &+ FROM TABLE(PD_GET_DIAG_HIST( 'MAIN', 'DX', '', CAST( CAST( (SQ_NO_AGG
C &+ R.END_TIME) AS TIMESTAMP) - 2 MINUTES AS TIMESTAMP), CAST( CAST(SQ_NO
C &+ _AGGR.END_TIME AS TIMESTAMP) + 2 MINUTES AS TIMESTAMP) ) )
C &+ WHERE FULLREC LIKE '%sqluxLogDataStats%BM#%MC#%' FETCH FIRST 1 ROW ON
C &+ LY )
C &+ , ' Bytes')) > 0 THEN 1.0/1024.0/1024.0
C &+ ELSE NULL
C &+ END ) AS BIGINT ) AS BIGINT) AS BACKUP_SIZE
C &+ FROM SYSIBM.SYSDUMMY1,
C &+ (SELECT CASE WHEN (SRC_BACKUP_HIST.START_TIME) IS NULL THEN 0 ELSE TIMESTAMPDIFF(2,CHAR(TIMESTAMP(SRC_B
C &+ ACKUP_HIST.END_TIME) - TIMESTAMP(SRC_BACKUP_HIST.START_TIME))) END AS OPERATION_RUNTIME2 ,
C &+ SRC_BACKUP_HIST.COMMENT AS COMMENT ,
C &+ SRC_BACKUP_HIST.DBPARTITIONNUM AS DBPARTITIONNUM ,
C &+ SRC_BACKUP_HIST.DEVICETYPE AS DEVICETYPE ,
C &+ SRC_BACKUP_HIST.EID AS EID ,
C &+ SRC_BACKUP_HIST.END_TIME AS END_TIME ,
C &+ SRC_BACKUP_HIST.ENTRY_STATUS AS ENTRY_STATUS ,
C &+ SRC_BACKUP_HIST.FIRSTLOG AS FIRSTLOG ,
C &+ SRC_BACKUP_HIST.LASTLOG AS LASTLOG ,
C &+ SRC_BACKUP_HIST.LOCATION AS LOCATION ,
C &+ SRC_BACKUP_HIST.NUM_TBSPS AS NUM_TBSPS ,
C &+ SRC_BACKUP_HIST.OBJECTTYPE AS OBJECTTYPE ,
C &+ SRC_BACKUP_HIST.OPERATION AS OPERATION ,
C &+ SRC_BACKUP_HIST.OPERATIONTYPE AS OPERATIONTYPE ,
C &+ SRC_BACKUP_HIST.SEQNUM AS SEQNUM ,
C &+ SRC_BACKUP_HIST.SQLCODE AS SQLCODE ,
C &+ SRC_BACKUP_HIST.SQLERRMC AS SQLERRMC ,
C &+ SRC_BACKUP_HIST.START_TIME AS START_TIME ,
C &+ SRC_BACKUP_HIST.TBSPNAMES AS TBSPNAMES
C &+ FROM SYSIBM.SYSDUMMY1,
C &+ TABLE( SYSPROC.ADMIN_LIST_HIST() ) AS SRC_BACKUP_HIST
C &+ WHERE SRC_BACKUP_HIST.DBPARTITIONNUM = ? AND
C &+ SRC_BACKUP_HIST.OPERATION = CAST(? AS CHARACTER(1)) AND
C &+ SRC_BACKUP_HIST.START_TIME >= CAST(? AS VARCHAR(14)) AND
C &+ SRC_BACKUP_HIST.START_TIME <= CAST(? AS VARCHAR(14)) ) AS SQ_NO_AGGR
C &+ ORDER BY START_TIME ASC ,
C &+ DBPARTITIONNUM ASC ,
C &+ SEQNUM DESC
C &+ WITH UR
C &+ DBA_COCKPIT( ISP, DB6_BACKUP_HISTORY )
Read more...
Environment
SAP on IBM Db2 for Linux, UNIX, and Windows
Keywords
BCD_OVERFLOW, Backup and recovery, DB02, DB12, backup history, Overflow during an arithmetic operation, type P , KBA , BC-DB-DB6-CCM , CCMS/Database Monitors , 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.