|
Problem IC99173
|
Status: Closed |
INSTANCE CAN TRAP WHEN INVOKING SQL ROUTINES THAT USE ARRAYS OF ROWS AND APPLICATION HEAP IS OUT OF MEMORY |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When invoking a SQL routine that uses arrays of rows the DB2
instance could trap if DB2 runs into an out of memory condition
(for example in the application heap) while processing that
array.
When DB2 traps, it can produce a stack trace as follows:
<StackTrace>
-------Frame------ ------Function + Offset------
0x0900000018CDBC5C
cloneDyn__20sqlriArrayDescriptorFP8sqlrr_cbP20sqlriArrayDescript
or + 0x234
0x090000001559248C
copy__20sqlriArrayDescriptorFP8sqlrr_cbP20sqlriArrayDescriptorb
+ 0x658
0x0900000018CD9A84
copyRowFieldDataToArrayElem__20sqlriArrayDescriptorFP8sqlrr_cbiP
18sqlriRowDescriptorP18dynamicArrayHeader + 0x67C
0x0900000018CD6CB0
setElement__20sqlriArrayDescriptorFP8sqlrr_cbiPUcT2T3N22 + 0x8D4
0x0900000018CDDADC
sqlriCopyNestedArrayMemory__FP8sqlrr_cbP20sqlriArrayDescriptorT2
+ 0x578
0x0900000018CDC970
cloneDyn__20sqlriArrayDescriptorFP8sqlrr_cbP20sqlriArrayDescript
or + 0xF48
0x090000001559248C
copy__20sqlriArrayDescriptorFP8sqlrr_cbP20sqlriArrayDescriptorb
+ 0x658
0x09000000169A17A0 sqlrxArrayCopy__FP8sqeAgentP10sqlz_valueT2b +
0x154
0x090000001592C1B0
sqlriRowDescCopy__FP8sqlrr_cbP18sqlriRowDescriptorT2 + 0x43C
0x09000000169A1C50 sqlvSqlPLCopyRow__FP8sqlrr_cbP10sqlz_valueT2
+ 0x3C
0x0900000017116664 copyData__3PVMFP10sqlz_valueT1Ulb + 0xB0
0x09000000170FC9E0 copyVariable__3PVMFUiT1 + 0xB0
0x09000000170FB12C run__3PVMFv + 0x998
0x09000000161F2420 pvm_entry + 0x464
0x0900000015D07C20 sqloInvokeFnArgs + 0xE0
0x09000000157B9CF0 sqloInvokeFnArgs@glue4D7 + 0x78
0x0900000015495720
sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntfb +
0x1D8
0x0900000015E314C8 sqlriInvokeInvoker__FP10sqlri_ufobb + 0xE0
0x0900000015F9A3BC sqlricall__FP8sqlrr_cb + 0x164
0x0900000015DA7384 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x24
0x0900000015DD248C sqlrr_process_execute_request__FP8sqlrr_cbib
+ 0xC34
0x0900000015DFE7E8
.sqlrr_execute.fdpr.clone.1971__FP14db2UCinterfaceP9UCstpInfo +
0xBC
0x0900000015DFDF74
.sqljs_ddm_excsqlstt.fdpr.clone.163__FP14db2UCinterfaceP13sqljDD
MObject + 0xAD4
0x0900000015DFD0FC
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x104
0x0900000015DFCEC4
.sqljsParse.fdpr.clone.43__FP13sqljsDrdaAsCbP14db2UCinterfaceP8s
qeAgentb + 0x6A8
0x0900000015DFBB84 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x2BC
0x0900000015F53024
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
0x0900000015F52D14
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x2D4
0x0900000015F5279C sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0x100
0x0900000015C46908 RunEDU__8sqeAgentFv + 0x310
0x0900000015C34BC4 EDUDriver__9sqzEDUObjFv + 0x100
0x0900000015C391F4 sqloEDUEntry + 0x264
</StackTrace> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7, Fixpack 10 *
**************************************************************** |
| Local Fix: |
Tune the appropriate DB2 parameters or increase system memory to
ensure that there is enough memory for the DB2 workload. |
| Solution |
First fixed in DB2 Version 9.7, Fixpack 10 |
| Workaround |
see Local Fix. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.02.2014
03.12.2014
03.12.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
