DB2 FOR LUW / DB2FORLUW / 970 - DB2

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.

**************************************************************** 
* 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.                                  * 
****************************************************************

Add all aggregate columns, i.e. COLX and COLY, to MQT select 
output list.

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
 

The customer should upgrade to DB2 V97 FP6 or higher versions 
to fix this issue.

Add all aggregate columns, i.e. COLX and COLY, to MQT select 
output list.

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84292 IC91742 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

11.11.2011
08.06.2012
08.06.2012

9.7.FP6