home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC68648 Status: Closed

REORGCHK TABLE FORMULAS F3 AND F5 MIGHT STILL ADVISE TO REORG A TABLE EVEN
THOUGH THE TABLE HAS BEEN REORG'ED.

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
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList
9.7.0.3 FixList