DB2 - Problembeschreibung
Problem IT01146 | Status: Geschlossen |
UPDATING INDEX CAN FAIL WITH SQLI_NOKEY "KEY NOT FOUND WITHIN NODE" | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
Abend occurs in rare situations where all of the following are present: Tables were created using NON_UNIQUE collating sequence Indexes are present and data contains multiple versions of the same key entry, ie "test" and "Test" In the db2diag.log, customer may see: 2014-03-10-11.29.26.059313-240 I11811512A765 LEVEL: Error PID : 6488336 TID : 34593 PROC : db2sysc 0 INSTANCE: db2advqp NODE : 000 DB : SADVDBQP APPHDL : 0-35622 APPID: *LOCAL.db2advqp.140310152728 AUTHID : SLBLDMGR EDUID : 34593 EDUNAME: db2agent (SADVDBQP) 0 FUNCTION: DB2 UDB, data management, sqldUpdateIndexes, probe:741 MESSAGE : ZRC=0x8709002C=-2029453268=SQLI_NOKEY "Key not found within node" DIA8541C The index key could not be found, the value was "". CALLED : DB2 UDB, index manager, sqlidelk RETCODE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR "non-severe dms programming error" DIA8532C An internal processing error has occurred. Followed by: 2014-03-10-11.29.26.059800-240 I11812278A687 LEVEL: Severe PID : 6488336 TID : 34593 PROC : db2sysc 0 INSTANCE: db2advqp NODE : 000 DB : SADVDBQP APPHDL : 0-35622 APPID: *LOCAL.db2advqp.140310152728 AUTHID : SLBLDMGR EDUID : 34593 EDUNAME: db2agent (SADVDBQP) 0 FUNCTION: DB2 UDB, data management, sqldUpdateIndexes, probe:1138 MESSAGE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR "non-severe dms programming error" DIA8532C An internal processing error has occurred. DATA #1 : String, 47 bytes Key data mismatch encountered during key update DATA #2 : String, 8 bytes sqldmupd | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to fix pack 5 or higher * **************************************************************** | |
Local-Fix: | |
NA | |
Lösung | |
First fixed in 10.5 fix pack 5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 18.04.2014 15.06.2015 15.06.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.5 |