|
Problem IC84292
|
Status: Geschlossen |
-901 ERROR WHILE COMPILING QUERY HAVING MULTIPLE AGGREGATE DISTINCT |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
Compiling a query may throw out -901 error "qnc was not found
when expected" with the following call stack
Compiler error stack for rc = -2144272209:
sqlnn_cmpl[370]
sqlnr_exe[1200]
sqlnr_rcc[100]
sqlnr_seq[100]
sqlnr_comp[110]
sqlnr_optprep_action[100]
sqlnr_optprep[2240]
sqlnr_compute_matchinfo[600]
sqlnq_som::compute_matchin[230]
sqlnq_mch::computeQclqncPP[900]
when query contains multiple aggregate distinct on different
columns, e.g. COUNT(DISTINCT COLX), COUNT(DISTINCT COLY) and the
query referenced base table has dependent optimizer MQT. An
optimizer MQT is such Materialized Query Table whose definition
is a SELECT from one or multiple base table with only join or
filtering predicate. |
| Problem-Zusammenfassung: |
|
| Local-Fix: |
Add all aggregate columns, i.e. COLX and COLY, to MQT select
output list. |
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
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
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Kommentar |
The Problem fixed |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 13.06.2012
29.03.2013
29.03.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
