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

INCORRECT INDEX SCAN OUTPUT AFTER ROLLFORWARD OF LOAD ... INDEXI NG MODE
REBUILD FOLLOWED BY LOAD ... INDEXING MODE INCREMENTAL.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
The error does not happen on HADR environments. 
 
After ROLLFORWARD, data stored in table and in index is out of 
sync. Data scan vs index scan will return different results 
(data is the correct one). Index may have some records missing, 
but all records in index are present in table. 
 
The scenario is rollforward through (both LOADs must be in 
rollforward window, and operate on same table). 
LOAD COPY YES ... INDEXING MODE REBUILD 
LOAD COPY YES ... INDEXING MODE INCREMENTAL 
 
ROLLFORWARD of LOAD COPY YES ... INDEXING MODE INCREMENTAL must 
mark indexes bad, as the COPY image does not contain any index 
data. 
Under certain scenarios (see below), index may not be marked 
bad. 
 
Rollforward window must include LOAD COPY YES ... INDEXING MODE 
REBUILD and LOAD COPY YES ... INDEXING MODE INCREMENTAL. 
At least one LOAD ... REBUILD must precede LOAD ... INCREMENTAL. 
Problem does not happen when LOAD ... REBUILD is the last LOAD.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* EE/DPF/SD, but not HADR                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 97 Fix Pack 10                        * 
****************************************************************
Local-Fix:
Force index rebuild. Either drop/recreate index, or mark index 
bad explicitly.
Lösung
Problem first fixed in Version 97 Fix Pack 10
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
25.07.2014
13.11.2014
13.11.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP10
Problem behoben lt. FixList in der Version
9.7.0.10 FixList