DB2 FOR LUW / DB2FORLUW / A50 - 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:                                              * 
* First fixed in fix pack 4 of DB2 v10.5                       * 
****************************************************************

N/A

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

First fixed in fix pack 4 of DB2 v10.5

keiner bekannt / siehe Local-Fix

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

20.01.2014
03.09.2014
03.09.2014