DB2 FOR LUW / DB2FORLUW / 970 - 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 v97 FP8 and lower                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V97 FP9                                       * 
****************************************************************

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 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First Fixed in DB2 V97 FP9

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC89670 IC91783 
follow-up : 

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

17.01.2013
17.12.2013
17.12.2013

9.7.FP9