|
Problem IC97954
|
Status: Closed |
EXCEPTIONALLY LONG COMPILATION TIME WHILE QUERY CONTAINS GROUPING SETS, ROLLUP OR CUBE |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V10.5 FP3 *
**************************************************************** |
| Local Fix: |
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. |
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem Fixed In DB2 V10.5 FP3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.11.2013
21.04.2014
21.04.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
