DB2 FOR LUW / DB2FORLUW / 970 - DB2

There is a problem with reogchk's F6 formula.  The formula tries 
to determine if the index can be reduce by 1 level if it were 
reorganized.  The formula doesn't account for the extra overhead 
in an index's root page, where we store, among other things, the 
index definition.  The more key parts you have, the bigger the 
index definition structure, the less room in the root page for 
keys and therefore the less leaf pages the index can have using 
(NLEVELS-1) levels in the tree.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7.0.6.                              * 
****************************************************************

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
 

The problem was first fixed in DB2 version 9.7.0.6.

keiner bekannt / siehe Local-Fix

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

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

05.03.2012
07.06.2012
07.06.2012

9.7.0.6