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 IC68942 Status: Geschlossen

SECTION ACTUALS CAN RETURN WRONG ROW COUNTS WHEN INTRA_PARALLEL IS SET TO
YES

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
If system is using SMP set-up (INTRA_PARALLEL db cfg parameter 
IS SET TO YES) , then collecting section explain with actuals to 
investigate poor query performance could return wrong row counts 
when the same query is executed more then once. 
 
Please, install this fix, or use information from one execution 
of the query only.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* SMP systems only                                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SECTION ACTUALS CAN RETURN WRONG ROW COUNTS WHEN             * 
* INTRA_PARALLEL                                               * 
* IS SET TO YES                                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* install this fix                                             * 
****************************************************************
Local-Fix:
use information from one execution of the query only
verfügbare FixPacks:
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a 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

Lösung
SECTION ACTUALS CAN RETURN WRONG ROW COUNTS WHEN INTRA_PARALLEL 
IS SET TO YES
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC68972 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
01.06.2010
16.09.2010
16.09.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.7.0.3 FixList
9.7.0.3 FixList