DB2 FOR LUW / DB2FORLUW / A10 - DB2

Under rare scenarios, performance degradation might be noticed 
if the following conditions are true: 
 
1. There is a sequence present in the output column of select 
list 
2. There are two or more views in the subselect directly below 
the sequence 
 
eg. 
select SEQUENCE1.NEXTVAL, col1, col2 
from view1 v1 
where v1.col1 = 
   (select MAX(col1) 
   from view1 v1 
   where col2 = ?);

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Users on DB2 V10 FP2 and earlier                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10 FP3                                       * 
****************************************************************

Separate the sequence into a new subselect: 
 
select SEQUENCE1.NEXTVAL , col1, col2 
from 
(select * 
from view1 v1 
where v1.col1 = 
   (select MAX(col1) 
   from view1 v1 
   where col2 = ?));

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

First Fixed in DB2 V10 FP3

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

22.04.2013
28.10.2013
28.10.2013