DB2 FOR LUW / DB2FORLUW / A50 - DB2

DB2 my produce SQL0901N The SQL statement or command failed 
because of a database system 
error (Reason "this pred does not push to all branch".) 
SQLSTATE=58004) or 
DB2 my produce SQL0901N The SQL statement or command failed 
because of a database system 
error (Reason "Column number out of range".)  SQLSTATE=58004 
 
if the following conditions are met: 
1. The query has join on UNION DISTINCT(UD) and SAP memory table 
2. There is a join predicate on UD and SAP memory table 
3. The UD has JOIN(s) 
 
Sample query: 
SELECT DISTINCT  * 
 FROM (SELECT  c1, c2 
FROM t1 
UNION SELECT DISTINCT  t2.c1, t2.c2 
FROM t2 
 LEFT OUTER JOIN t3 ON ( t2.c1 = t3.c1  ) ) t , 
TABLE( SAPTOOLS.MEMORY_TABLE ( CAST( '' AS BLOB( 2G )) ) ) AS 
"t_00" (  "C_2" VARCHAR(60) ) 
 WHERE  t.c2 = "t_00"."C_2";

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 10.5 Fix Pack 9 or higher                     * 
****************************************************************

query optimization level 1 or use db2set 
DB2COMPOPT=NO_BLU_SAP_MEMTBL

First fixed in Db2 10.5 Fix Pack 9

not known / see Local fix

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

29.06.2017
29.09.2017
29.09.2017

9.0.