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

REORG MONITOR REPORTS INCORRECT MAX COUNT FOR BUILD PHASE WHEN
INTRA_PARALLEL IS ON

Produkt:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problembeschreibung:
Reorg monitoring feature (available in DB2 version 9.1 Fixpack 
8) reports the progress of index reorganization. For build phase 
the progress indicators are: the current record being processed 
(Cur Count) and the maximum number of records to process 
(Max Count). 
 
The Max Count for build phase is collected during the scan-sort 
phase. When the registry variable INTRA_PARALLEL is enabled, and 
the index has more than 200 nodes, the index creation will use 
parallel agents to perform scanning and sorting. During this 
parallel index creation the code sets Max Count variable too 
early and starts the build phase prematurely. 
 
The problem does not occur with serial index build which is 
the default index creation method. 
 
Users will observe incorrect Max Count value (e.g. that is less 
that Cur Count) and possibly incorrect Cur Count value, as well.
Problem-Zusammenfassung:
During the parallel index creation the code which sets the Max 
Count variable executes too early and starts the build phase 
prematurely (i.e., without waiting for all sort agents to 
return).
Local-Fix:
Setting the registry variable INDEXSORT to NO will bypass 
parallel index creation; however, it may have impact on reorg 
performance.
verfügbare FixPacks:
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Lösung
The fix is to serialize the actions proparly such that the 
monitoring code will wait for all sort agents to finish before 
updating the Max Count counter and starting the build phase.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.07.2009
10.11.2009
10.11.2009
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.1.0.9 FixList