| Neueste Versionen | FixList |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
DB2 - Problembeschreibung
| Problem IC68648 | Status: Geschlossen |
REORGCHK TABLE FORMULAS F3 AND F5 MIGHT STILL ADVISE TO REORG A TABLE EVEN THOUGH THE TABLE HAS BEEN REORG'ED. | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problembeschreibung: | |
For F3 we have :
F3 = 100 * activeblocks / ( (fpages_adjust / tExtentSize) - 1
);
However, it should have been :
F3 = 100 * activeblocks / ( (fpages_adjust / tExtentSize) -
(numberOfTablePartitions * numberOfDatabasePartitions) );
For F5 we have:
F5 = (100 * (fullkeycard * (leaf_recsize + leafRecOverhead) +
(activeblocks - fullkeycard) * dupkeySize)) /
((nleaf - neleaf - 1) * (iPageSize - leaf_page_overhead))
Steps to reproduce :
reproduce the problem on db2_v95fp6_linuxamd64_s100428 with 3
logical nodes using the following script:
#!/bin/ksh
# Assume 3 logical nodes
dbName="wsdb"
export DB2OPTIONS="-ctv"
db2start
db2 "create db $dbName"
db2 "connect to $dbName"
db2 "create table s1.t1 (i1 int, i2 int) partition by range (i2)
(starting 1 ending 10 every 1) organize by (i2)"
db2 "insert into s1.t1 values (0,1), (0,2), (0,3), (0,4), (0,5),
(0,6), (0,7), (0,8), (0,9), (0,10)"
db2 "runstats on table s1.t1 and indexes all"
db2 "call sysproc.reorgchk_tb_stats('T','S1.T1')"
db2 "reorg table s1.t1"
db2 "call sysproc.reorgchk_tb_stats('T','S1.T1')"
db2 "drop table s1.t1"
db2 "terminate"
db2stop
Db2 gives false advise about reorg because of the incorrect
formula for F3 and F5. | |
| Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * CLP REORGCHK command users * **************************************************************** * PROBLEM DESCRIPTION: * * REORGCHK TABLE FORMULAS F3 AND F5 MIGHT STILL ADVISE TO * * REORG A * * TABLE EVEN THOUGH THE TABLE HAS BEEN REORG'ED. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 9.07.3 * **************************************************************** | |
| Local-Fix: | |
| verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows | |
| Lösung | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC69700 Nachfolger : | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 14.05.2010 24.09.2010 24.09.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.7.3 | |
| Problem behoben lt. FixList in der Version | |
| 9.7.0.3 |
|
| 9.7.0.3 |
|