| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| 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 |
|
