DB2 - Problembeschreibung
Problem IC85638 | Status: Geschlossen |
CRASH USING ARRAY DATA TYPE AND NESTED TYPES WITH PL SQL PRAGMA AUTONOMOUS TRANSACTION | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
DB2 instance will crash when using the PL SQL PRAGMA AUTONOMOUS TRANSACTION involving array data type with nested data types scenario. For example array of rows. The crash will occur only if array data types and nested data types are used with PRAGMA AUTONOMOUS TRANSACTION. A trap file will be created with the function stack below: <freeArrayOfRowLobMem> <sqlriArrayDescriptor::destroyChild> <sqlriArrayDescriptor::destroyAllChildren> <sqlriArrayDescriptor::destroy> <sqlerCopyRowOrArrayNestedData> <sqlerAutonomousRoutine::applicationSessionUnpackPsrs> <sqlerAutonomousRoutine::Finalize> <sqlerAutonomousInvoker> <sqlriAutonomousCall> (rest of stack truncated) | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Apply DB2 version 10 Fixpack 2 to the database server. * **************************************************************** | |
Local-Fix: | |
Do not use PRAGMA AUTONOMOUS TRANSACTION with array data types involving nested data types | |
Lösung | |
Problem first fixed in DB2 version 10 Fixpack 2. This fix should be applied to the DB2 database server. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 31.07.2012 31.12.2012 31.12.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |