|
Problem IC81807
|
Status: Closed |
PROBLEM WITH REORGCHK FORMULA F6 |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7.0.6. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 |
The problem was first fixed in DB2 version 9.7.0.6. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84485 IC84608
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.03.2012
07.06.2012
07.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.0.6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
