DB2 FOR LUW / DB2FORLUW / A10 - DB2

In DPF environment, when a SQL statement meets the following 
conditions, compiling it can take a long time or run out of 
memory (SQL0101N) 
 
1. Two tables are joined together using a lot of equality 
   predicates. 
2. One (or both) of the tables is a derived table that is 
   derived from a query that contains a group by clause, and 
   such group by clause have a lot of group by columns. 
3. Some (or all) of the group by columns participate in the 
equality join predicates. 
 
For example 
 
select ... 
from (select ... from T group by <a lot of columns>) as T1, T2 
where <a lot of equality join predicates>

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 UDB Version 10.1                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 10.1 FixPack 3.                           * 
****************************************************************

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 UDB Version 10.1 FixPack 3.

not known / see Local fix

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

19.02.2013
01.10.2013
01.10.2013