DB2 FOR LUW / DB2FORLUW / 950 - DB2

Sometimes a table can have 0 row yet occupy many empty pages. 
This situation can occur if you delete 
all rows from a table that originally contained a lot of rows, 
and you don't reorg the table afterwards. 
DB2 optimizer can generate a sub-optimal query plan when such a 
table is involved in a SQL statement.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Sometimes a table can have 0 row yet occupy many empty       * 
* pages.                                                       * 
* This situation can occur if you delete                       * 
* all rows from a table that originally contained a lot of     * 
* rows,                                                        * 
* and you don't reorg the table afterwards.                    * 
* DB2 optimizer can generate a sub-optimal query plan when     * 
* such a                                                       * 
* table is involved in a SQL statement.                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2V95FP9 or higher                        * 
****************************************************************

reorg the table

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 was fixed on DB2V95FP9 or higher

reorg the table.

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

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

12.07.2011
12.03.2012
12.03.2012

9.5.FP9