IBM Support

IZ36182: DURING APPLICATION CONNECTION RESET OR TERMINATION, DB2 TRAPS WHEN TRYING TO FREE UP QUERY SECTIONS AND ITS SIBLINGS.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • During application connection reset or application termination,
    db2 is invoked to clean up the resources used by this
    application.  During this procedure, db2 navigates through the
    package directory and clean all the packages along with its
    sections.  When it is trying to clean up the siblings of a
    section, it traps with the following stack:
    
    *************************************
    
          sqlra_sqlC_release_sibling + 0x258
          sqlra_sqlC_free_section_entry + 0x890
          sqlra_sqlC_free_sdir + 0x8
          sqlra_sqlC_free_pkg + 0x190
          sqlra_sqlC_free_pdir + 0x1c8
          sqlra_sqlC_free_all + 0x1cc
          sqlrr_appl_term + 0xd8c
          sqlesrsp
          sqlesrspWrp
          sqleUCagentConnectReset
          sqljsDrdaAsDriver
          sqleRunAgent
          sqloCreateEDU
          sqloSpawnEDU
          sqleCreateNewAgent
          sqleGetAgentFromPool
          sqleGetAgent
    
    *************************************
    
    This APAR will fix the fault code that references the resource
    that has already been freed.
    

Local fix

Problem summary

  • During application connection reset or application termination,
    db2 is invoked to clean up the resources used by this
    application.  During this procedure, db2 navigates through the
    package directory and clean all the packages along with its
    sections.  When it is trying to clean up the siblings of a
    section, it traps with the following stack:
    
    *************************************
    
          sqlra_sqlC_release_sibling + 0x258
          sqlra_sqlC_free_section_entry + 0x890
          sqlra_sqlC_free_sdir + 0x8
          sqlra_sqlC_free_pkg + 0x190
          sqlra_sqlC_free_pdir + 0x1c8
          sqlra_sqlC_free_all + 0x1cc
          sqlrr_appl_term + 0xd8c
          sqlesrsp
          sqlesrspWrp
          sqleUCagentConnectReset
          sqljsDrdaAsDriver
          sqleRunAgent
          sqloCreateEDU
          sqloSpawnEDU
          sqleCreateNewAgent
          sqleGetAgentFromPool
          sqleGetAgent
    
    *************************************
    
    This APAR will fix the fault code that references the resource
    that has already been freed.
    

Problem conclusion

  • Defect => wsdbu00369215
    Module => engn_sqr
    Fixed in => V9.1 FP7 (s090308)
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ36182

  • Reported component name

    DB2 UDB ESE SOL

  • Reported component ID

    5765F4102

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-10-30

  • Closed date

    2009-04-24

  • Last modified date

    2009-04-24

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

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

    IZ36183

Fix information

  • Fixed component name

    DB2 UDB ESE SOL

  • Fixed component ID

    5765F4102

Applicable component levels

  • R910 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 April 2009