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
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.
SAP Knowledge Base Article - Preview