DB2 FOR LUW / DB2FORLUW / 970 - DB2

Here is an example. If run a select similar below : 
SELECT A, B FROM FROM TAB1 ORDER BY A FETCH FIRST xxxxx ROW 
ONLY; 
 
And the table TAB1 has a lot of same data, it may take time as 
below : 
 
   FFNR 1400000 Total sort time (ms)                       = 
9217 
   FFNR 1300000 Total sort time (ms)                       = 
1084199 
 
1400000 rows case faster than 1300000 rows case. 
Larger number of rows faster than small number of rows 
unexpectedly.

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 UDB Version 9.7                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 FixPack 11.                           * 
****************************************************************

Problem was first fixed in DB2 UDB Version 9.7 FixPack 11.

keiner bekannt / siehe Local-Fix

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

26.05.2015
11.10.2015
11.10.2015

9.7.FP11