|
Problem IC79752
|
Status: Closed |
-901 ERROR WHILE COMPILING QUERY HAVING MULTIPLE AGGREGATE DISTINCT |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: |
****************************************************************
* USERS AFFECTED: *
* All DB2 Users *
****************************************************************
* PROBLEM DESCRIPTION: *
* -901 ERROR WHILE COMPILING QUERY HAVING MULTIPLE AGGREGATE *
* DISTINCT *
****************************************************************
* RECOMMENDATION: *
* The customer should upgrade to DB2 V97 FP6 or higher *
* versions to fix this issue. *
**************************************************************** |
| Local Fix: |
Add all aggregate columns, i.e. COLX and COLY, to MQT select
output list. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
The customer should upgrade to DB2 V97 FP6 or higher versions
to fix this issue. |
| Workaround |
Add all aggregate columns, i.e. COLX and COLY, to MQT select
output list. |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84292 IC91742
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.11.2011
08.06.2012
08.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
