home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList