DB2 FOR LUW / DB2FORLUW / A10 - DB2

A query may exhibit hanging symptom during its compilation when 
all the following conditions are met: 
1. Query has outer join construct. 
2. One stream input to the outer join is a subquery having 
CONNECT BY clause. 
3. The same subquery that contains CONNECT BY also has 
correlation predicate, i.e. a predicate referencing column from 
outer query block. 
 
To verify if the query hits this problem, use db2pd -dump and 
search the following call stack in the dump file: 
 
correlation_fromqun 
sqlnr_OJprd_pushdown 
sqlnr_optprep

**************************************************************** 
* USERS AFFECTED:                                              * 
* A QUERY MAY HANG WHEN IT CONTAINS CONNECT BY AND LEFT OUTER  * 
* JOIN                                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please move to fix pack 4 of DB2 v10.1                       * 
****************************************************************

N/A

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

Please move to fix pack 4 of DB2 v10.1

not known / see Local fix

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

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

18.09.2013
02.06.2014
02.06.2014