DB2 FOR LUW / DB2FORLUW / A10 - 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 10 Fixpack 2 to the database server.       * 
****************************************************************

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

Problem first fixed in DB2 version 10 Fixpack 2.  This fix 
should be applied to the DB2 database server.

not known / see Local fix

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

31.07.2012
31.12.2012
31.12.2012