DB2 FOR LUW / DB2FORLUW / 970 - DB2

Description: 
 
A query might fail with a SQL0901N error code if the following 
are true: 
1. The MQT definition is simply a select from one base table or 
multiple base tables joined together 
2. The user has enforced replicate MQT through either one of : 
     i. optguidelines 
     ii. DB2_EXTENDED_OPTIMIZATION=FORCE_REPLICATED_MQT_MERGE 
 
In the db2diag.log an error message such as the following may be 
seen: 
 
2011-02-02-00.37.29.943200-300 E671418998E802      LEVEL: Info 
(Origin) 
PID     : 28374                TID  : 47901128517952PROC : 
db2sysc 1 
INSTANCE: db2inst1             NODE : 001          DB   : SAMPLE 
APPHDL  : 1-57167              APPID: 
10.139.25.214.32786.11030715355 
AUTHID  : DB2INST1 
EDUID   : 5407                 EDUNAME: db2agent (SAMPLE) 1 
FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650 
MESSAGE : ZRC=0x803100AF=-2144272209=SQLNN_E_BADNEWS 
          "unexpected error but state is OK" 
DATA #1 : String, 257 bytes 
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[360] 
sqlnq_mch::cleanUpForOpt[50]

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A query that has an MQT definition as a select from one base * 
* table or multiple base tables joined together and where the  * 
* user has enforced replicate MQT through optguidelines or     * 
* DB2_EXTENDED_OPTIMIZATION=FORCE_REPLICATED_MQT_MERGE may     * 
* result in a SQL0901N error.                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 5.                       * 
****************************************************************

N/A

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 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
 

First fixed in Version 9.7 Fix Pack 5.

keiner bekannt / siehe Local-Fix

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

15.03.2011
03.01.2012
03.01.2012

9.7.FP5