DB2 FOR LUW / DB2FORLUW / 970 - DB2

In V97 fixpack 4 only, if a query contains a "like" predicate 
where the column is a "long" type 
such as long varchar, then there is a small timing window that 
might cause a memory corruption 
when a section is being freed during the sql workspace memory 
management logic. 
 
Since this timing window is small, the actual symptom of the 
corruption has never 
been seen to date, but the exposure has been identified and 
fixed with this APAR. 
 
Because this is a memory corruption, there may be a few 
different possible symptoms, and 
an instance crash is possible. However, the problem itself was 
only discovered when certain 
memory debug options were enabled, which changed the timing and 
memory conditions that 
enabled the discovery of the problem. 
 
In that case, a crash was detected with the following stack: 
 
sqlri_like_free 
sqlricls_complex 
sqlricls 
sqlriecc 
sqlriCloseExecuteSectionComplex 
sqlriCloseExecuteSection 
sqlrr_process_execute_request 
sqlrr_execute 
sqljs_ddm_excsqlstt 
sqljsParseRdbAccessed 
sqljsParse

**************************************************************** 
* USERS AFFECTED:                                              * 
* 97FP4 users using LIKE processing with LONG predicates and   * 
* memory debug options turned on.                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Crash during LIKE processing with LONG predicates and memory * 
* debug options turned on.                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V97FP5 containing the fix.                        * 
****************************************************************

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
 

Fixed in 97FP5.

keiner bekannt / siehe Local-Fix

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

24.08.2011
19.01.2012
19.01.2012

9.7.FP5