DB2 FOR LUW / DB2FORLUW / 970 - DB2

The DB2 query rewrite phase of optimization might be able to 
improve the performance of an SQL statement compiled using 
optimization class 5 if it includes a join with a view that is 
defined with a union all operation, such as 
 
CREATE VIEW view1 
AS 
SELECT ... FROM tabA ... 
UNION ALL 
SELECT ... FROM tabB ... 
 
and the statement references multiple columns from the view in a 
range join with a base table, such as 
 
SELECT 
... 
FROM view1, tabC ... 
WHERE tabC.x between view1.y and view1.z ... 
 
You can identify this scenario by capturing an EXPLAIN of the 
statement and verifying in the optimized statement section or 
access plan that the join is performed after the UNION 
operation. 
 
This enhancement is only available under registry variable 
control. To enable it, issue: 
db2set 
DB2_UNION_OPTIMIZATION="[<other-values>,]ENABLE_UA_RANGE_JPPD=ON 
[,<other-values>]" 
and restart the database manager for settings to take effect.

**************************************************************** 
* USERS AFFECTED:                                              * 
* all users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.7 FP10 or higher                               * 
****************************************************************

Use optimization class 7 or higher.

keiner bekannt / siehe Local-Fix

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

17.01.2014
09.12.2014
09.12.2014

9.7.FP10