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 |