DB2 FOR LUW / DB2FORLUW / B10 - DB2

Description:
DB2 may through 901 if a query has the following properties:
1) An atomic table function that returns result of join on same
table
2) A join with the table function
3) IN/EXIST predicate having a join

Example:
CREATE FUNCTION tf ()
RETURNS TABLE (tfc1 int)
BEGIN ATOMIC
    RETURN
        select x.t4c1
        from t4 x, t4 y
        ;--
END;

select t.*,t1c1 from TABLE(tf()) as t
, T1
where t1c1 in (SELECT t2c1 FROM T2, T3);

Workaround:
Turn off DEEPKYPU by
1) db2set DB2COMPOPT=NO_DEEPKEYPU or
2) using optimizer guideline to impact on the query only:
 /* 




*/

****************************************************************
* USERS AFFECTED:                                              *
* -                                                            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* -                                                            *
****************************************************************

not known / see Local fix

forerunner  : IT15900 
follow-up : 

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

13.07.2016
10.10.2017
10.10.2017