|
Problem IC84292
|
Status: Closed |
-901 ERROR WHILE COMPILING QUERY HAVING MULTIPLE AGGREGATE DISTINCT |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 Summary: |
|
| Local Fix: |
Add all aggregate columns, i.e. COLX and COLY, to MQT select
output list. |
| available fix packs: |
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
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Comment |
The Problem fixed |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.06.2012
29.03.2013
29.03.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
