DB2 FOR LUW / DB2FORLUW / 970 - DB2

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)

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply DB2 version 9.7 Fixpack 8 to DB2 database server.      * 
****************************************************************

Do not use PRAGMA AUTONOMOUS TRANSACTION with array data types 
involving nested data types

DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem first fixed in DB2 version 9.7 Fixpack 8.  This is a DB2 
server side fix and should be applied to the DB2 server.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC85638 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

31.07.2012
08.04.2013
08.04.2013

9.7.FP8