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

REORG_CURRENT_COUNTER IS LESS THAN REORG_MAX_COUNTER ON COMPLETED REORGS IN
SYSIBMADM.SNAPTAB_REORG, DB2PD AND DB2TOP.

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
In certain inplace reorg scenarios, it is possible for monitor 
information to show that REORG_CURRENT_COUNTER is less than 
REORG_MAX_COUNTER when the REORG_STATUS is completed. A similar 
issue exists with db2pd and db2top where the reorg percentage is 
below 100% even though the reorg has successfully completed. 
 
This is purely a cosmetic issue rather than a functional issue 
and the reorg has actually completed. 
 
Sample output follows: 
 
db2 "select substr(TABNAME,1,24) as tabname 
REORG_CURRENT_COUNTER, REORG_MAX_COUNTER, REORG_STATUS, 
REORG_COMPLETION from sysibmadm.snaptab_reorg where 
REORG_CURRENT_COUNTER < REORG_MAX_COUNTER" 
 
TABNAME REORG_CURRENT_COUNTER REORG_MAX_COUNTER REORG_STATUS 
REORG_COMPLETION 
---------- --------------------- ----------------- 
--------------------------------------------- 
TABLE1    263088                           522111 
COMPLETED      SUCCESS 
 
 
 
db2pd -db sample -reorg 
 
Address                    TbspaceID TableID PartID MasterTbs 
MasterTab   TableName    Type    IndexID    TempSpaceID 
 
0x00002AAD685CA128 2              3592    n/a     n/a 
n/a             TABLE1         Online  0             2 
 
 
 
Address                    TableName Start 
End                         PhaseStart MaxPhase   Phase 
CurCount   MaxCount   Status   Completion 
0x00002AAD685CA128 TABLE1     08/12/2014 06:05:11 08/12/2014 
07:06:18   n/a           n/a           n/a          263088 
522111     Done      0
Problem-Zusammenfassung:
In certain inplace reorg scenarios, it is possible for monitor 
information to show that REORG_CURRENT_COUNTER is less than 
REORG_MAX_COUNTER when the REORG_STATUS is completed. A similar 
issue exists with db2pd and db2top where the reorg percentage is 
below 100% even though the reorg has successfully completed. 
 
This is purely a cosmetic issue rather than a functional issue 
and the reorg has actually completed. 
 
Sample output follows: 
 
db2 "select substr(TABNAME,1,24) as tabname 
REORG_CURRENT_COUNTER, REORG_MAX_COUNTER, REORG_STATUS, 
REORG_COMPLETION from sysibmadm.snaptab_reorg where 
REORG_CURRENT_COUNTER < REORG_MAX_COUNTER" 
 
TABNAME REORG_CURRENT_COUNTER REORG_MAX_COUNTER REORG_STATUS 
REORG_COMPLETION 
---------- --------------------- ----------------- 
--------------------------------------------- 
TABLE1    263088                           522111 
COMPLETED      SUCCESS 
 
 
 
db2pd -db sample -reorg 
 
Address                    TbspaceID TableID PartID MasterTbs 
MasterTab   TableName    Type    IndexID    TempSpaceID 
 
0x00002AAD685CA128 2              3592    n/a     n/a 
n/a             TABLE1         Online  0             2 
 
 
 
Address                    TableName Start 
End                         PhaseStart MaxPhase   Phase 
CurCount   MaxCount   Status   Completion 
0x00002AAD685CA128 TABLE1     08/12/2014 06:05:11 08/12/2014 
07:06:18   n/a           n/a           n/a          263088 
522111     Done      0
Local-Fix:
NA
Lösung
First fixed in DB2 Version 10.5 FixPack 5.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.08.2014
18.11.2014
18.11.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.5 FixList