DB2 FOR LUW / DB2FORLUW / 950 - DB2

In DB2 9.7 new meta data has been added to all index root pages. 
During database upgrade we check if there is enough space to 
upgrade the root page page and if there is not, then we mark the 
entire index object as invalid and the index will be rebuilt 
after database upgrade.  Index rebuild can take several hours on 
large tables and will acquire and hold a Z lock on the table for 
the entire duration of the index rebuild.  This can leave the 
database unusable for several hours after the upgrade. 
 
This change prevents the index manager from filling up an index 
root page beyond the point where there would not be enough space 
to upgrade it to 9.7 or later.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See the error description field.                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.5.0.9.                                      * 
****************************************************************

DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

The problem is first fixed in DB2 9.5.0.9.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

10.08.2011
19.03.2012
19.03.2012

9.5.0.9