IBM Support

IC76697: DB2 instance maybe crash with signal 11 when array is taken as an input of the SQL SP and intra_parallel is enabled.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The instance could be crashed (signal 11) with the following
    callstack when array is taken as an input of the SQL SP and
    intra_parallel is enabled.
    
    Here's a sample of the stack dump:
    
    destroy__20sqlriArrayDescriptorFv@AF439_78 + 0xC
    destroy__20sqlriArrayDescriptorFv@glue104F + 0x74
    sqlricls_complex__FP8sqlrr_cbilN23 + 0x1358
    @87@sqlricls__FP8sqlrr_cbiN32 + 0x64
    sqlriecc__FP8sqlrr_cbilT3 + 0x1058
    sqlriCloseExecuteSectionComplex__FP8sqlrr_cbi + 0x4AC
    sqlrr_process_execute_request__FP8sqlrr_cbi + 0x948
    sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0xFC
    executeSection__10pvmPackageFP5sqlcaUib + 0x8D8
    executeQuery__3PVMFUib + 0x1B0
    run__3PVMFv + 0x9FC
    pvm_entry + 0x31C
    sqloInvokeFnArgs + 0xB0
    sqloInvokeFnArgs@glue64C + 0x74
    sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf
    +0x1154
    sqlriInvokeInvoker__FP10sqlri_ufob + 0x848
    sqlricall__FP8sqlrr_cb + 0x7C
    sqlriAggressiveValidateOp__FP8sqlrr_cb + 0x108
    sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 0x6C8
    sqlrr_process_execute_request__FP8sqlrr_cbi - 0x258
    sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x240
    sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x968
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface
    - 0x48
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124
    @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x1D8
    @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98
    @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0
    sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0xD8
    RunEDU__8sqeAgentFv + 0x11C
    EDUDriver__9sqzEDUObjFv + 0x78
    sqloEDUEntry + 0x57C
    

Local fix

  • Turn off Intra_Parallel at the instance level.
    

Problem summary

  • The instance could be crashed (signal 11) with the following
    callstack when array is taken as an input of the SQL SP and
    intra_parallel is enabled.
    
    Here's a sample of the stack dump:
    
    destroy__20sqlriArrayDescriptorFv@AF439_78 + 0xC
    destroy__20sqlriArrayDescriptorFv@glue104F + 0x74
    sqlricls_complex__FP8sqlrr_cbilN23 + 0x1358
    @87@sqlricls__FP8sqlrr_cbiN32 + 0x64
    sqlriecc__FP8sqlrr_cbilT3 + 0x1058
    sqlriCloseExecuteSectionComplex__FP8sqlrr_cbi + 0x4AC
    sqlrr_process_execute_request__FP8sqlrr_cbi + 0x948
    sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0xFC
    executeSection__10pvmPackageFP5sqlcaUib + 0x8D8
    executeQuery__3PVMFUib + 0x1B0
    run__3PVMFv + 0x9FC
    pvm_entry + 0x31C
    sqloInvokeFnArgs + 0xB0
    sqloInvokeFnArgs@glue64C + 0x74
    sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf
    +0x1154
    sqlriInvokeInvoker__FP10sqlri_ufob + 0x848
    sqlricall__FP8sqlrr_cb + 0x7C
    sqlriAggressiveValidateOp__FP8sqlrr_cb + 0x108
    sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 0x6C8
    sqlrr_process_execute_request__FP8sqlrr_cbi - 0x258
    sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x240
    sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x968
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface
    - 0x48
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124
    @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x1D8
    @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98
    @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0
    sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0xD8
    RunEDU__8sqeAgentFv + 0x11C
    EDUDriver__9sqzEDUObjFv + 0x78
    sqloEDUEntry + 0x57C
    

Problem conclusion

  • This APAR is fixed on the DB2 v9.7FP5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC76697

  • 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

    2011-05-31

  • Closed date

    2011-07-19

  • Last modified date

    2011-07-19

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

    IV00725

  • 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 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC76697

Modified date: 19 July 2011