DB2 FOR LUW / DB2FORLUW / A10 - DB2

Database crashes with the following stack: 
 
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 
0x020a 
ossDumpStackTraceV98 + 0x002b 
_ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x0103 
sqlo_trce + 0x0407 
sqloEDUCodeTrapHandler + 0x0277 
sqloCrashOnCriticalMemoryValidationFailure + 0x0020 
sqlofmblkEx + 0x051d 
_ZN14sqlnq_ulintSet7freeMemEv + 0x0062 
_ZN15sqlnrDBConnInfo12freeMqtListsEv + 0x00bf 
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq 
lrr_cmpl_enviiPP9sqlnq_qur + 0x1eb5 
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq 
lrr_cmpl_env + 0x0021 
 
This is a rare defect where a replicated MQT enforcement is 
specified by either the registry control variable 
DB2_EXTENDED_OPTIMIZATION or by the optimization guideline.  The 
query has a high number of subquery blocks that can be matched 
to the replicated MQT and DB2 is unable to access the allocated 
memory across multiple invocations of the DB2 compiler. 
 
- The problem is introduced by v10.1 fix pack 3 APAR IC91051 
- The only fix packs that contain this problem are v10.1 fix 
pack 3 and v10.5 fix pack 3 
- v9.7 doesn't have the problem

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v10.1 fix pack 4.                             * 
****************************************************************

1. Unset registry control, or take off optimization guideline 
that enforces the replicated MQT. 
2. Rewrite query statement to use the replicated MQT directly.

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in DB2 v10.1 fix pack 4.

See local fix.

Vorgänger  : APAR is sysrouted TO one or more of the following: IC98085 IC98378 
Nachfolger : 

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

03.12.2013
26.06.2014
26.06.2014