IBM Support

JR37601: Instance crashes when doing Federated Two Phase Commit within an autonomous procedure

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Instance crashes when doing Federated Two Phase Commit within an
    autonomous procedure
    The problem only happens within an autonomous transaction and
    when F2PC is enabled for the server.
    
    The crashing call stack is as following:
    0x00002B50EB497239 sqlo_md_mchk + 0x00e9
    0x00002B50EB49764A sqlo_md_mcpy + 0x0194
    0x00002B50EB77EE71 _Z11sqlqgGenXidP11SQLP_TENTRYP11sqlxa_xid_t +
    0x0169
    0x00002B50EB77E30B _Z13sqlqgFedStartP14UnfencedServerc + 0x08f9
    0x00002B50EB765BEF _Z12sqlqgOpenIUDP10sqlri_riud + 0x03f3
    0x00002B50EBD29DA6 _Z11sqlriDjxDelP8sqlrr_cb + 0x012a
    

Local fix

  • Avoid to use Federated Two Phase Commit within an autonomous
    procedure
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * The users using  Federated Two Phase Commit within an        *
    * autonomous procedure.                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Instance crashes when doing Federated Two Phase Commit       *
    * within an autonomous procedure                               *
    * The problem only happens within an autonomous transaction    *
    * and when F2PC is enabled for the server.                     *
    *                                                              *
    * The crashing call stack is as following:                     *
    * 0x00002B50EB497239 sqlo_md_mchk + 0x00e9                     *
    * 0x00002B50EB49764A sqlo_md_mcpy + 0x0194                     *
    * 0x00002B50EB77EE71                                           *
    * _Z11sqlqgGenXidP11SQLP_TENTRYP11sqlxa_xid_t + 0x0169         *
    * 0x00002B50EB77E30B _Z13sqlqgFedStartP14UnfencedServerc +     *
    * 0x08f9                                                       *
    * 0x00002B50EB765BEF _Z12sqlqgOpenIUDP10sqlri_riud + 0x03f3    *
    * 0x00002B50EBD29DA6 _Z11sqlriDjxDelP8sqlrr_cb + 0x012a        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to the latest fixpack.                               *
    ****************************************************************
    

Problem conclusion

  • This fix should be applied on the federation server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR37601

  • Reported component name

    FEDERATED RUNTI

  • Reported component ID

    5724N9703

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-08-26

  • Closed date

    2011-04-28

  • Last modified date

    2011-04-28

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

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

Fix information

  • Fixed component name

    FEDERATED RUNTI

  • Fixed component ID

    5724N9703

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPX","label":"Federated Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
28 April 2011