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.

not known / see Local fix

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

26.05.2015
11.10.2015
11.10.2015

9.7.FP11