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

DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

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 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