DB2 FOR LUW / DB2FORLUW / A10 - DB2

When a DPF query contains supper group by clause including 
grouping sets, rollup and cube, and if the same group by block 
reference many group-by columns in its select clause, long 
compilation may be observed. Run db2pd -dump and if 
"sqlnq_qun::propagate_equivalent_pair" is found in the call 
stack, then this APAR is hit.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.1 FP3                                     * 
****************************************************************

Either change query optimization to level 0, 1, or 3 and the 
query may be compiled successfully, or filter out such queries 
by reducing STMTHEAP to let query compiler quickly exhausts 
memory and returns message SQL0101N before it attempts the CPU 
intensive optimization.

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
 

Fixed in DB2 V10.1 FP3

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC97954 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

22.03.2013
16.12.2013
16.12.2013