home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT09090 Status: Geschlossen

FFNR, FETCH FIRST N ROW ONLY MAY TAKE TIME UNEXPECTEDLY.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 UDB Version 9.7                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 FixPack 11.                           * 
****************************************************************
Local-Fix:
Lösung
Problem was first fixed in DB2 UDB Version 9.7 FixPack 11.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
26.05.2015
11.10.2015
11.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP11
Problem behoben lt. FixList in der Version
9.7.0.11 FixList