DB2 - Problem description
Problem IC68648 | Status: Closed |
REORGCHK TABLE FORMULAS F3 AND F5 MIGHT STILL ADVISE TO REORG A TABLE EVEN | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
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 Summary: | |
**************************************************************** * 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: | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC69700 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 14.05.2010 24.09.2010 24.09.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.7.3 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.3 | |
9.7.0.3 |