IC84608: PROBLEM WITH REORGCHK FORMULA F6

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error 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.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 version 10 fixpack 1                          *
  ****************************************************************
  

Problem conclusion

• Problem was first fixed in DB2 version 10 fixpack 1
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IC81807

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RA10 PSN

     UP