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

SQL STATEMENT WITH UNCORRELATED SUBQUERY PREDICATE MIGHT RETURN INCORRECT
RESULTS WHEN INTRA_PARALLEL IS ENABLED

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
An SQL statement that satisfies the following conditions might 
return an incorrect result set containing values that do not 
qualify the clauses in the WHERE clause when INTRA_PARALLEL is 
enabled: 
- the statement contains an uncorrelated subquery predicate 
nested within an uncorrelated EXISTS subquery predicate 
- the query optimizer converts the EXISTS subquery to a join 
- the access plan generated by the optimizer is parallelized 
 
The following is an example of a statement that satisfies the 
above conditions 
 
SELECT DISTINCT A1 FROM T1 
WHERE EXISTS (SELECT A2 FROM T2 WHERE B2 <> ALL (SELECT B3 FROM 
T3 WHERE A3 BETWEEN 1 and 10);
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.5.0.4.                             * 
****************************************************************
Local-Fix:
Disable INTRA_PARALLEL for the problematic statement by setting 
the CURRENT DEGREE special register to 1.
verfügbare FixPacks:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
The problem is first fixed in DB2 version 10.5.0.4.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
16.04.2014
08.09.2014
08.04.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList