DB2 FOR LUW / DB2FORLUW / A10 - DB2

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);

Users Affected: All users 
Problem Description: see error description

Disable INTRA_PARALLEL for the problematic statement by setting 
the CURRENT DEGREE special register to 1.

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem is first fixed in DB2 UDB version 
10.1 fix pack 4

keiner bekannt / siehe Local-Fix

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

04.03.2014
18.07.2014
18.07.2014