DB2 - Problembeschreibung
Problem IT00610 | Status: Geschlossen |
ROLLFORWARD OF A RESTORED DATABASE MAY FAIL WITH: DIA8575C AN INDEX MANAGER PROGRAMMING ERROR OCCURED | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
The following points need to be true to run into this situation during rollforward: * Backup needs to take a long time to complete for a tablespace * An additional space map page needs to be allocated to the index object during backup before truncate table * Index object needs to change (truncate table) after object table has been archived but before index object is archived * Index object needs to contain more than one space map page The rollforward of the additional space map page after the restore, before the truncate table, will fail with the following messages in the db2diag.log file: 2014-02-15-06.59.39.779236+000 I2200215A525 LEVEL: Severe PID : 21626960 TID : 13462 PROC : db2sysc 0 INSTANCE: xxxxx NODE : 000 DB : yyy APPHDL : 0-3427 APPID: *LOCAL.xxxxx.140215062931 AUTHID : xxxxx EDUID : 13462 EDUNAME: db2redow (yyy) 0 FUNCTION: DB2 UDB, index manager, sqliRedoInitSMP, probe:2693 RETCODE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program error" DIA8575C An index manager programming error occurred. ... 2014-02-15-06.59.39.824851+000 I2201631A525 LEVEL: Severe PID : 21626960 TID : 13462 PROC : db2sysc 0 INSTANCE: xxxxx NODE : 000 DB : yyy APPHDL : 0-3427 APPID: *LOCAL.xxxxx.140215062931 AUTHID : xxxxx EDUID : 13462 EDUNAME: db2redow (yyy) 0 FUNCTION: DB2 UDB, index manager, sqliRedoInitSMP, probe:4950 RETCODE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program error" DIA8575C An index manager programming error occurred. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 10. * **************************************************************** | |
Local-Fix: | |
Lösung | |
First fixed in DB2 Version 9.7 Fix Pack 10. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.03.2014 09.12.2014 09.12.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP10 | |
Problem behoben lt. FixList in der Version | |
9.7.0.10 |