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 IC69339 Status: Geschlossen

REPLAY OF CERTAIN INTERNAL INDEX OPERATIONS DURING ROLLFORWARD OR CRASH
RECOVERY MAY FAIL WITH ERROR DIA8575C

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Replay of certain internal index operations when rolling 
forward, either as part of recovery or on an HADR standby, can 
lead to a miscalculation of the free space on an index page 
resulting in this error being reported: 
 
2010-05-14-21.58.21.582815+120 I18806675E585       LEVEL: Error 
PID     : 24382                TID  : 46912854026560PROC : 
db2sysc 
INSTANCE: INST1                  NODE : 000          DB   : 
SAMPLE 
APPHDL  : 0-17                 APPID: *LOCAL.DB2.100507185408 
EDUID   : 85                   EDUNAME: db2redow (SAMPLE) 
FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:155 
MESSAGE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program 
error" 
          DIA8575C An index manager programming error occurred. 
DATA #1 : <preformatted> 
REDO failed on LSO(LSN) 15666791888120 (00000E519B932CEF) 
 
This db2diag.log entry is preceded by a message of function 
sqliakn at probe 901: 
 
2010-05-14-21.58.21.465469+120 I18763255E646       LEVEL: Severe 
PID     : 24382                TID  : 46912854026560PROC : 
db2sysc 
INSTANCE: INST1                  NODE : 000          DB   : 
SAMPLE 
APPHDL  : 0-17                 APPID: *LOCAL.DB2.100507185408 
EDUID   : 85                   EDUNAME: db2redow (SAMPLE) 
FUNCTION: DB2 UDB, index manager, sqliakn, probe:901 
MESSAGE : slotinfo 
DATA #1 : Hexdump, 40 bytes
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Replay of certain internal index operations when             * 
* rollingforward, either as part of recovery or on an HADR     * 
* standby,canlead to a miscalculation of the free space on an  * 
* index pageresulting in this error being                      * 
* reported:2010-05-14-21.58.21.582815+120 I18806675E585        * 
* LEVEL:ErrorPID    : 24382                TID  :              * 
* 46912854026560PROC :db2syscINSTANCE: INST1                   * 
* NODE : 000          DB  :SAMPLEAPPHDL  : 0-17                * 
* APPID: *LOCAL.DB2.100507185408EDUID  : 85                    * 
* EDUNAME: db2redow (SAMPLE)FUNCTION: DB2 UDB, recovery        * 
* manager, sqlpRecDbRedo,probe:155MESSAGE :                    * 
* ZRC=0x87090054=-2029453228=SQLI_PRG_ERR                      * 
* "Programerror"DIA8575C An index manager programming          * 
* erroroccurred.DATA #1 : <preformatted>REDO failed on         * 
* LSO(LSN) 15666791888120 (00000E519B932CEF)This db2diag.log   * 
* entry is preceded by a message of functionsqliakn at probe   * 
* 901:2010-05-14-21.58.21.465469+120 I18763255E646             * 
* LEVEL:SeverePID    : 24382                TID  :             * 
* 46912854026560PROC :db2syscINSTANCE: INST1                   * 
* NODE : 000          DB  :SAMPLEAPPHDL  : 0-17                * 
* APPID: *LOCAL.DB2.100507185408EDUID  : 85                    * 
* EDUNAME: db2redow (SAMPLE)FUNCTION: DB2 UDB, index manager,  * 
* sqliakn, probe:901MESSAGE : slotinfoDATA #1 : Hexdump, 40    * 
* bytes                                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 FP3                                      * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 V9.7 FP3
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC69801 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
18.06.2010
27.09.2010
27.09.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP3
Problem behoben lt. FixList in der Version
9.7.0.3 FixList
9.7.0.3 FixList