IBM Support

JR29852: DB2 CRASH WITH CORRUPT STACK CALLING SYSIBM.SQLPROCEDURECOLS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Db2 can crash with the following stacks on calling
    SYSIBM.SQLPROCEDURECOLS:
    
    <SignalDetails>
    Exception C000001D Occurred
    Exception Address = 2EB926C0
    </SignalDetails>
    
    <StackTrace>
    <![CDATA[
    --EBP------EIP------ARGS-----------------------------
    2EB916E8 2EB926C0 BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB
    BBBBBBBB BBBBBBBB 00000000 00000000 00000000 00000000
    ]]></StackTrace>
    
    or
    
    <StackTrace>
    <![CDATA[
    --EBP------EIP------ARGS-----------------------------
    18BA16E8 18BA26C0 20202020 5341432C 3F282054 20534120
    20202020 20202020 00000000 00000000 00000000 00000000
    ]]></StackTrace>
    
    or
    
    <StackTrace>
    <![CDATA[
    --EBP------EIP------ARGS-----------------------------
    25128F94 0BDE7FED 00000006 00000081 1757A718 0BE1807C offset:
    00006933 in <sqltables> <NotFound:-1>
    1757A828 0BDE7616 BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB offset:
    00005F5C in <sqltables> <NotFound:-1>
    1757A828 BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB
    BBBBBBBB BBBBBBBB 00000000 00000000 00000000 00000000
    ]]></StackTrace>
    <StackDump>
    <Frame num="1">
    <![CDATA[^M
    25127FDC :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    25127FEC :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    25127FFC :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512800C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512801C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512802C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512803C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512804C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512805C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512806C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512807C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512808C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512809C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    251280AC :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    
    All the above show a corrupt stack which has been overwritten on
    the call to SQLPROCEDURECOLS
    

Local fix

  • N/A
    

Problem summary

  • USER AFFECTED: ALL
    PROBLEM DESCRIPTION:DB2 CRASH WITH CORRUPT STACK CALLING
    SYSIBM.SQLPROCEDURECOLS
    PROBLEM SUMMARY:
    ERROR DESCRIPTION:
    Db2 can crash with the following stacks on calling
    SYSIBM.SQLPROCEDURECOLS:
    
    <SignalDetails>
    Exception C000001D Occurred
    Exception Address = 2EB926C0
    </SignalDetails>
    
    <StackTrace>
    <![CDATA[
    --EBP------EIP------ARGS-----------------------------
    2EB916E8 2EB926C0 BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB
    BBBBBBBB BBBBBBBB 00000000 00000000 00000000 00000000
    ]]></StackTrace>
    
    or
    
    <StackTrace>
    <![CDATA[
    --EBP------EIP------ARGS-----------------------------
    18BA16E8 18BA26C0 20202020 5341432C 3F282054 20534120
    20202020 20202020 00000000 00000000 00000000 00000000
    ]]></StackTrace>
    
    or
    
    <StackTrace>
    <![CDATA[
    --EBP------EIP------ARGS-----------------------------
    25128F94 0BDE7FED 00000006 00000081 1757A718 0BE1807C offset:
    00006933 in <sqltables> <NotFound:-1>
    1757A828 0BDE7616 BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB offset:
    00005F5C in <sqltables> <NotFound:-1>
    1757A828 BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB
    BBBBBBBB BBBBBBBB 00000000 00000000 00000000 00000000
    ]]></StackTrace>
    <StackDump>
    <Frame num="1">
    <![CDATA[^M
    25127FDC :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    25127FEC :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    25127FFC :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512800C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512801C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512802C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512803C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512804C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512805C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512806C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512807C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512808C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    2512809C :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    251280AC :BBBBBBBB BBBBBBBB BBBBBBBB BBBBBBBB ................
    
    All the above show a corrupt stack which has been overwritten on
    the call to SQLPROCEDURECOLS
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.50, FixPak 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR29852

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-07-08

  • Closed date

    2009-03-09

  • Last modified date

    2009-03-09

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

    JR29850

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

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • 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:
09 March 2009