DB2 FOR LUW / DB2FORLUW / 950 - DB2

When the following conditions are all met,  compiling a query or 
modifying statement may trap with stack: 
 
sqlnq_qtboprparent::op 
sqlnq_mch::is_maximal 
sqlnq_som::compute_matchinfo_opt 
sqlnr_compute_matchinfo 
sqlnr_optprep 
sqlnr_optprep_action 
 
 
(1) There are at least two replicated MQT (Materialized Query 
Table) and at least one non-replicated optimizer MQT or 
statistical view. An optimizer MQT is such MQT whose definition 
is simply "SELECT <expression list> FROM <one or more base 
tables> WHERE <predicates>". 
(2) Registry variable DB2_EXTENDED_OPTIMIZATION includes flag 
FORCE_REPLICATED_MQT_MERGE. 
(3) The query statement itself contains multiple subqueries, or 
the modifying statement's target table has multiple enforced 
checking constraint defined.

**************************************************************** 
* USERS AFFECTED:                                              * 
* N/A                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fix Pack 9.                       * 
****************************************************************

DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

Fixed on DB2 Version 9.5 Fix Pack 9.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC79863 IC84184 
Nachfolger : 

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

07.11.2011
26.04.2012
26.04.2012

9.5.FP9