DB2 FOR LUW / DB2FORLUW / A50 - DB2

When compiling an UPDATE or DELETE SQL statement, DB2 can return 
error code SQL0901 with the following error message: 
 
SQL0901N  The SQL statement or command failed because of a 
database system error. (Reason "Unable to form a plan for all 
QUNs.".) SQLSTATE=58004 
 
The following conditions must be present 
(1) "REDUCE_LOCKING" is set in registry variable 
DB2_REDUCED_OPTIMIZATION 
(2) greedy join enumeration is used to compile the SQL statement 
(3) the table that is to be updated or to be deleted from is a 
correlation source of another table 
 
The following are some common scenarios of when greedy join 
enumeration is used. Note that this is not a complete list. 
- when optimization class is 0, 1, or 2 
- when stmtheap size is too small to complete dynamic 
programming join enumeration 
- when DB2_REDUCED_OPTIMIZATION has a number as the first 
component and REDUCE_LOCKING elsewhere in the registry string, 
and some additional conditions are satisfied. Please refer to 
DB2 InfoCentre for the conditions.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 4                       * 
****************************************************************

First fixed in DB2 Version 10.5 Fix Pack 4

not known / see Local fix

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

16.05.2014
08.09.2014
08.09.2014