DB2 FOR LUW / DB2FORLUW / B50 - DB2

Description:
Db2 query may generate incorrect result when the following
conditions are met:
-This is an update query
-There is correlation in the subselect
-There is predicate on source and target table column in the
subselect

****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 v11.5.4.0 or higher                           *
****************************************************************

Set one of the two registry variables mentioned below (which are
on by default from 11.1).
It will take effect immediately for newly compiled SQL
statements.
might need to flush the package cache for dynamic statements
that were previously compiled.
Static sections will need to be rebound.
>db2set -immediate DB2COMPOPT="NO_UPDATE_COMP"
or
db2set -immediate DB2COMPOPT="NO_SCALARQ2LOJ"
--No instance recycle needed.

not known / see Local fix

forerunner  : IT31525 
follow-up : 

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

23.01.2020
30.06.2020
30.06.2020