DB2 FOR LUW / DB2FORLUW / 970 - DB2

When a procedure is invoked from a trigger, a dynamic compound 
statement, an SQL function or SQL method checking is required 
to ensure the integrity of the database and raise SQL0746N 
errors if need be. 
 
 (See "Data conflicts when procedures read from or write to 
tables" in the product documentation for more information 
on this topic.) 
 
When the procedures make use of DBMS_SQL routines, references 
to internal constructs related to this checking are cached 
and are not correctly purged when the constructs are freed, 
leaving stale references. 
 
Problems only occur when further executions of the DBMS_SQL 
routines take place within the same connection as they 
attempt to use the stale references. 
 
Stacks associated with the problem will normally start with 
memory management functions - likely falsely reporting memory 
corruption - but will always include a function starting with 
"sqlriRWCon". 
 
An example stack: 
 
    sqloCrashOnCriticalMemoryValidationFailure 
    sqloCrashOnCriticalMemoryValidationFailure@glue707 
    sqlofmblkEx 
    sqlra_sqlC_mem_free_block__FP8sqlrr_cbUlPv 
    sqlriRWConCheck__FP8sqlrr_cbUiP14sqlriTableInfo 
    sqlriRWConCheck__FP8sqlrr_cbUiP14sqlriTableInfo@glue1032 
    sqlriSectInitializeSimple__FP8sqlrr_cbP9sqlri_shdb 
    ...

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 10                       * 
****************************************************************

First fixed in DB2 Version 9.7 Fix Pack 10

not known / see Local fix

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

21.03.2014
11.11.2014
11.11.2014

9.7.FP10