DB2 FOR LUW / DB2FORLUW / 970 - DB2

An example SQL: 
---------------------------------------------------------------- 
SELECT LEVEL FROM DUAL CONNECT BY NOCYCLE LEVEL <= 10 
---------------------------------------------------------------- 
 
Since the virtual table DUAL has 1 row, the intermediate result 
table Hn+1 would return the same row as the one that is already 
in the hierarchical path. According to the documentation, the 
NOCYCLE keyword will not include the repeated row. This is an 
intended behaviour in DB2, which is different from Oracle 
behaviour.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 9.                       * 
****************************************************************

Rewrite the query using DB2 syntax. The following technotes may 
be of help: 
http://www.ibm.com/developerworks/data/library/techarticle/dm-05 
10rielau/ 
http://www.ibm.com/developerworks/ibmi/library/i-db2connectby/in 
dex.html

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
 

Upgrade to DB2 Version 9.7 Fix Pack 9.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC95385 IC96280 
follow-up : 

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

13.12.2012
18.12.2013
18.12.2013

9.7.FP9