DB2 FOR LUW / DB2FORLUW / A10 - DB2

DB2 might abend when running a query with the following
characteristics:

1. the query has at least one outer join(OJ)
2. on the row preserving(RP) side of this OJ, there are multiple
table inner join(IJ)
3. a local predicates applied on at least 2 inner joined tables
on the RP side of the OJ reference the same constants; one of
these local predicates references a column output to the OJ and
this column is also used in an OJ predicate

With the criteria above met, an invalid correlation could be
formed during Outer Join to Semi Join transformation. Depending
on when and how this bad correlation is detected, a message of
-901 and a stack can differ.

The workaround is to turn off OJSJ transformation.

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to db2_v111m4fp6 or later                            *
****************************************************************

db2set -im DB2COMPOPT=NOOJSJ

not known / see Local fix

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

03.06.2020
14.01.2021
14.01.2021