|
Problem IC85629
|
Status: Closed |
CRASH USING ARRAY DATA TYPE AND NESTED TYPES WITH PL SQL PRAGMA AUTONOMOUS TRANSACTION |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Apply DB2 version 9.7 Fixpack 8 to DB2 database server. *
**************************************************************** |
| Local Fix: |
Do not use PRAGMA AUTONOMOUS TRANSACTION with array data types
involving nested data types |
| available fix packs: |
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
|
| Solution |
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. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC85638
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.07.2012
08.04.2013
08.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
