IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.5 Fix Pack 9 or higher.             *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 Version 9.5 Fix Pack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV00725

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-05-19

  • Closed date

    2012-03-27

  • Last modified date

    2012-03-27

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

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

    IC76697

Fix information

  • Fixed component name

    DB2 UDB ESE AIX

  • Fixed component ID

    5765F4100

Applicable component levels

  • R950 PSN

       UP

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
27 March 2012