home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT00467 Status: Geschlossen

DB2 MAY TRAP WHEN CHECKING FOR PROCEDURE DATA CONFLICTS WHEN DBMS_SQL
ROUTINES ARE USED

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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 
    ...
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 10                       * 
****************************************************************
Local-Fix:
Lösung
First fixed in DB2 Version 9.7 Fix Pack 10
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
21.03.2014
11.11.2014
11.11.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP10
Problem behoben lt. FixList in der Version
9.7.0.10 FixList