|
Problem IC97954
|
Status: Geschlossen |
EXCEPTIONALLY LONG COMPILATION TIME WHILE QUERY CONTAINS GROUPING SETS, ROLLUP OR CUBE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| verfügbare FixPacks: |
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
|
| Lösung |
Problem Fixed In DB2 V10.5 FP3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 26.11.2013
21.04.2014
21.04.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
