|
Problem IT03880
|
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 / 970 - 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 9.7 Fixpack 10. |
| Workaround |
NA |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 20.08.2014
18.12.2014
18.12.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP10
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.10
|
 |
