IBM Support

LI73706: SIGNAL #11 IN SQLDDCOPYDDWHEN A SQL STORED PROCEURE IS RAN UNDER SPECIFIC CONDITIONS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • if SQL procedure is defined with a result set cursor as "RETURN
    TO CLIENT", and if the size of the non-lob data being returned
    in a column is bigger than aslheapsz defined in dbm cfg, the
    db2agent that executes the SQL procedure will trap with sig #11
    with the following stack:
    .
    <StackTrace>
    ---FUNC-ADDR---- ------FUNCTION + OFFSET------
    0000002A9B1A85D8 ossDumpStackTrace + 0x0080
    0000002A9B1A629C _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x00aa
    0000002A98202FC3 sqlo_trce + 0x033b
    0000002A96E4C7A4 sqloEDUCodeTrapHandler + 0x0074
    0000002A957D34F0 address: 0x0000002A957D34F0 ; dladdress:
    0x0000002A957C7000 ; offset in lib: 0x000000000000C4F0 ;
    0000002A96E5DC3A sqloCrashOnCriticalMemoryValidationFailure +
    0x001a
    0000002A96E6E3FC
    _ZN8SMemPool32diagnoseMemoryCorruptionAndCrashEmPKc + 0x01f4
    0000002A96E6C2CD
    _ZN8SMemPool10MemTreeGetEmmPPvPP17SqloChunkSubgroupPP12SMemLostN
    ode + 0x00bd
    0000002A96E6E681
    _ZN8SMemPool19allocateMemoryBlockEmmmjmPPvPP17SqloChunkSubgroupP
    P12SMemLostNodeP12SMemLogEvent + 0x00c9
    0000002A96E5E3C7 sqlogmblkEx + 0x077f
    0000002A968CDB25
    _Z11sqlddCopyDDP8SMemPoolPP14dataDescriptorS2_jmPmPKcm + 0x04a7
    0000002A97FF7B78 _Z17sqlerAnchorCursorP14db2UCinterface + 0x04a0
    0000002A9829BD27 _Z16csmCursorBlasterP14db2UCinterfacejjPjjj +
    0x06ff
    0000002A97A3A644
    _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntf +
    0x1f3c
    0000002A97A37CB2 _Z18sqlriInvokeInvokerP10sqlri_ufob
    

Local fix

  • The workaroun dis to increase aslheapsz in the dbm cfg
    

Problem summary

  • if SQL procedure is defined with a result set cursor as "RETURN
    TO CLIENT", and if the size of the non-lob data being returned
    in a column is bigger than aslheapsz defined in dbm cfg, the
    db2agent that executes the SQL procedure will trap with sig #11
    with the following stack:
    .
    <StackTrace>
    ---FUNC-ADDR---- ------FUNCTION + OFFSET------
    0000002A9B1A85D8 ossDumpStackTrace + 0x0080
    0000002A9B1A629C _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x00aa
    0000002A98202FC3 sqlo_trce + 0x033b
    0000002A96E4C7A4 sqloEDUCodeTrapHandler + 0x0074
    0000002A957D34F0 address: 0x0000002A957D34F0 ; dladdress:
    0x0000002A957C7000 ; offset in lib: 0x000000000000C4F0 ;
    0000002A96E5DC3A sqloCrashOnCriticalMemoryValidationFailure +
    0x001a
    0000002A96E6E3FC
    _ZN8SMemPool32diagnoseMemoryCorruptionAndCrashEmPKc + 0x01f4
    0000002A96E6C2CD
    _ZN8SMemPool10MemTreeGetEmmPPvPP17SqloChunkSubgroupPP12SMemLostN
    ode + 0x00bd
    0000002A96E6E681
    _ZN8SMemPool19allocateMemoryBlockEmmmjmPPvPP17SqloChunkSubgroupP
    P12SMemLostNodeP12SMemLogEvent + 0x00c9
    0000002A96E5E3C7 sqlogmblkEx + 0x077f
    0000002A968CDB25
    _Z11sqlddCopyDDP8SMemPoolPP14dataDescriptorS2_jmPmPKcm + 0x04a7
    0000002A97FF7B78 _Z17sqlerAnchorCursorP14db2UCinterface + 0x04a0
    0000002A9829BD27 _Z16csmCursorBlasterP14db2UCinterfacejjPjjj +
    0x06ff
    0000002A97A3A644
    _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntf +
    0x1f3c
    0000002A97A37CB2 _Z18sqlriInvokeInvokerP10sqlri_ufob
    

Problem conclusion

  • module engn_sqdd
    fixed >= fixpack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI73706

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-07-30

  • Closed date

    2009-03-08

  • Last modified date

    2009-03-08

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

    IZ28655

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

Modules/Macros

  • ENG_SQDD
    

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSN

       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:
08 March 2009