DB2 FOR LUW / DB2FORLUW / 970 - DB2

Memory overwrite can happen when arrays with elements of large 
size are used (example: create type arrayCLOB as clob(2M) 
array[]) and  assignments to the same element in array either 
fluctuate greatly: 
 
set size large 
set size tiny 
set size large 
set size tiny 
etc.. 
 
or go up: 
 
set size large 
set size larger 
set size even larger 
set size even larger then before 
etc.. 
 
This can occur when calling MONREPORT.CURRENTSQL routine. 
 
The stack trace can be vary since this is memory corruption 
problem. Here is an example: 
 
pdLog 
diagnoseMemoryCorruptionAndCrash 
MemTreePreallocateAndInsert 
allocateMemoryBlock 
sqlogmblkEx 
allocateDyn 
setElement 
appendElement 
sqlriArrayAgg 
sqlriagg 
sqlriSectInvoke 
sqlrr_process_execute_request 
sqlrr_execute 
run 
pvm_entry 
sqloInvoke 
sqlriInvokerTrusted 
sqlriInvokeInvoke 
sqlricall 
 ...

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using array data types.                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 9.                       * 
****************************************************************

Not using array data types.

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 

First fixed in DB2 Version 9.7 Fix Pack 9.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

07.08.2013
12.02.2014
12.02.2014

9.7.FP9