DB2 FOR LUW / DB2FORLUW / A10 - DB2

A query may fail with sql0901 with the text: 
"Missing dimension key memory for zzjn feedback deep copy" 
 
For the problem to occur, the following conditions are known to 
lead to the error: 
- The access plan for the query contains a zig zag join 
- The mentioned join is between unequal join key lengths between 
the dimension tables and the fact table, likely caused by having 
the zzjn exist under a union.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to fixpack 5                                         * 
****************************************************************

Set the environment registry variable : 
db2set DB2_REDUCED_OPTIMIZATION="ZZJN OFF". 
By doing so, we ensure that DB2 will avoid using Zigzag join in 
the access plan.

Problem fixed in DB2 v10.1 fixpack 5.

not known / see Local fix

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

24.06.2014
13.07.2015
13.07.2015