SAP Knowledge Base Article - Preview

2679945 - DB6: Shortdump BCD_OVERFLOW is raised when trying to view backup history

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 for DB2 Universal Database , 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.