DB2 FOR LUW / DB2FORLUW / 970 - DB2

The statistics of a partitioned index may not be representative 
after data partition detach occurs. The statistics stored in 
syscat.indexpartitions and syscat.indexes may show 
inconsistency. For example, nlevels in syscat.indexes is 0 while 
none of nlevels in syscat.indexpartitions is 0. 
 
To determine if this problem affects a particular table: 
 
1. Collect db2cat output: db2cat -d dbname -s schema -n table -o 
db2cat.out 
 
2. Find the "Data Partitioning DESCRIPTION" section, for 
example: 
 
          Data Partitioning DESCRIPTION 
          ----------------------------- 
 Flags                     : PARTITIONED 
 Number partitions         : 5 
 Number partitioning cols  : 1 
 MAX Data Partition ID     : 7 
 
3. If "MAX Data Partition ID" is greater than "Number 
partitions", the table might experience the problem.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users with table partitioning data organization          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 Fix Pack 6                            * 
****************************************************************

Manually update the statistics in sysstat.indexes to a non-zero 
value or consult DB2 support for a value to be used for the 
manual update.

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 Version 9.7 Fix Pack 6

See Local Fix

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

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

14.11.2011
14.06.2012
14.06.2012

9.7.FP6