home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC91639 Status: Closed

MEMORY OVERWRITE CAN HAPPEN WHEN ARRAYS WITH ELEMENTS OF LARGE SIZE ARE
USED.

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
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 
 ...
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 3.                      * 
****************************************************************
Local Fix:
Not using array data types.
available fix packs:
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
First fixed in Version 10.1 Fix Pack 3.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC94718 IC95258 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
17.04.2013
24.10.2013
17.01.2014
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.3 FixList
10.1.0.3 FixList