SAP Knowledge Base Article - Preview

3237765 - DB2 database crash with "FODC_IndexError".

Symptom

Your Db2 database crashes with FODC_IndexError. 

Just before the crash you observe these errors in the db2diag.log:

2022-06-03-12.10.40.111233-240 I220377442E583        LEVEL: Severe
PID     : 80443                TID : 140292384614144 PROC : db2sysc 0
INSTANCE: db2sap               NODE : 000            DB   : P40
APPHDL  : 0-62094              APPID: *LOCAL.db2sap.220603155427
AUTHID  : db2sap               HOSTNAME: usirv99a02n01
EDUID   : 1940                 EDUNAME: db2agent (P40) 0
FUNCTION: DB2 UDB, index manager, procT2Leaf2Del, probe:7
RETCODE : ZRC=0x8709002C=-2029453268=SQLI_NOKEY "Key not found within node"
          DIA8541C The index key could not be found, the value was "".
          
2022-06-03-12.10.40.131953-240 E220382998E803        LEVEL: Error
PID     : 80443                TID : 140292384614144 PROC : db2sysc 0
INSTANCE: db2sap               NODE : 000            DB   : P40
APPHDL  : 0-62094              APPID: *LOCAL.db2sap.220603155427
AUTHID  : db2sap               HOSTNAME: usirv99a02n01
EDUID   : 1940                 EDUNAME: db2agent (P40) 0
FUNCTION: DB2 UDB, index manager, sqliDumpPageFromAllMembers, probe:20
MESSAGE : ADM14005E  The following error occurred: "IndexError".  First 
          Occurrence Data Capture (FODC) has been invoked in the following 
          mode: "Automatic".  Diagnostic information has been recorded in the 
          directory named 
          "/db2/SAP/db2dump/FODC_IndexError_2022-06-03-12.10.40.131743_80443_1940_000/".

 

Checking the stack in FODC_IndexError_YYYY-MM-DD-HH.MM.SS.MMMMMM, you see the following:

sqlischdP7SQLI_CBP11SQLI_SDGLOBtj + 0x26e4
sqlidelkP8sqeAgentP9SQLD_IXCBP10SQLI_IXPCRP8SQLD_KEY8SQLZ_RIDmP16SQLB_OBJECT_DESC + 0x05f7
sqldVirtualColumnDeleteKeyP8sqeAgentP13SQLD_DFM_WORK8SQLZ_RIDtm + 0x0142
sqldbOlrDeleteEmptyITCBlockP8sqeAgentP13SQLD_DFM_WORKP8SQLD_TCB + 0x0b52
sqldbPerformItcOlrRowMovementP8sqeAgentP13SQLD_DFM_WORKP18SQLD_OLR_INTERRUPTP8SQLD_TCB + 0x0471
sqldOnlineTableReorgP8sqeAgenttthmittPciS1_iP9SQLP_LSN8S3_si + 0x3356
sqlrreorg_tableP8sqlrr_cbttP8sqlrg_idtiimiisPhiS3_iishi + 0x10bc
sqlrreorg_sendinfoP14db2UCinterfacei + 0x2332
sqlrr_reorgP14db2UCinterfacei + 0x0171
sqlerKnownProcedureiPcPiP5sqldaS2_P13sqlerFmpTableP8sqeAgentP5sqlca + 0x1349
sqlerCallDLP14db2UCinterfaceP9UCstpInfo + 0x139d
sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x0618
sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x010b
sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x054e


Read more...

Environment

  • DB2 11.1 prior to release 11.1.4.5

Product

SAP ERP 6.0

Keywords

FODC_IndexError IndexError DIA8541C ADM14005E , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.