DB2 FOR LUW / DB2FORLUW / A50 - 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 Cancun Release 10.5.0.4 (also known as Fix    * 
* Pack 4) or higher.                                           * 
****************************************************************

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 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4).

See Local Fix

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

17.12.2013
22.09.2014
22.09.2014