IBM Support

IC99173: INSTANCE CAN TRAP WHEN INVOKING SQL ROUTINES THAT USE ARRAYS OF ROWS AND APPLICATION HEAP IS OUT OF MEMORY

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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>
    

Local fix

  • Tune the appropriate DB2 parameters or increase system memory to
    ensure that there is enough memory for the DB2 workload.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7, Fixpack 10                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7, Fixpack 10
    

Temporary fix

  • see Local Fix.
    

Comments

APAR Information

  • APAR number

    IC99173

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-02-05

  • Closed date

    2014-12-03

  • Last modified date

    2014-12-03

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC99173

Modified date: 03 December 2014