DB2 FOR LUW / DB2FORLUW / 970 - DB2

reorgchk can return incorrect values for LEAF_RECSIZE & 
NLEAF_RECSIZE result in incorrect F5 & F6 values. 
 
The SYSPROC.REORGCHK_IX_STATS does not use the same calculation 
and therefore does not have the same issue. 
 
Issue is reproducible by creating a table with varchar column 
and performing the reorgchk. No partitioned table required.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.7 Fixpack 8 or Later                           * 
****************************************************************

Use the stored procedure version (SYSPROC.REORGCHK_IX_STATS) 
instead of the reorgchk CLP version.

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
 

First Fixed in v9.7 Fixpack 8

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC90117 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

30.09.2012
08.04.2013
08.04.2013

9.7.FP8