IC84292: -901 ERROR WHILE COMPILING QUERY HAVING MULTIPLE AGGREGATE DISTINCT
Fixes are available
Closed as user error.
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 sqlnr_exe sqlnr_rcc sqlnr_seq sqlnr_comp sqlnr_optprep_action sqlnr_optprep sqlnr_compute_matchinfo sqlnq_som::compute_matchin sqlnq_mch::computeQclqncPP 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.
Add all aggregate columns, i.e. COLX and COLY, to MQT select output list.
The Problem fixed
Reported component name
DB2 FOR LUW
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following: