DB2 FOR LUW / DB2FORLUW / 970 - DB2

The performance impact is as follows, when performing a load on 
a table with a reasonable number of range partitions, say 1000, 
the load mistakenly marks all indexes in error for each range 
partition. As the number of local indexes is at least equal to 
the number of range partitions, in this scenario 1000x1000 
markings will occur when only 1000 need to occur. As a results 
a load of 3000 rows takes over 1 hour to complete when instead 
it should complete under five minutes. The load completes in 
under five minutes when the fix is applied.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Version 9.7 All Platforms                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A load replace or load restart of a load of 3000 rows takes  * 
* over 1 hour to complete when instead it should complete      * 
* under five minutes, when it is on a range partitioned table  * 
* with local indices. The load completes in under five minutes * 
* when the fix is applied. This problem only becomes           * 
* noticeable when we use local indices and range partitioning, * 
* with hundreds of ranges.                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 Fix Pack 1 or later.                  * 
****************************************************************

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 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 9a 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 10 for Linux, UNIX, and Windows
 

Performance problem was first fixed in Version 9.7 Fix Pack 1. 
At a minimum, this fix should be applied on the server.

keiner bekannt / siehe Local-Fix

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

29.07.2009
05.02.2010
05.02.2010

9.7.FP1