PH45312: SHARING LOCKS WITH AN EXTERNAL STORED PROCEDURE

APAR status

• Closed as new function.

Error description

• SHARING LOCKS WITH AN EXTERNAL STORED PROCEDURE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 remote users of External Stored                      *
  * Procedures                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Remote users of External Stored                              *
  * Procedures want to call with a XID                           *
  * so the DDF agent can share locks                             *
  * with another Db2 agent that has been                         *
  * called by the stored procedure.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Remote users of External Stored
  Procedures want to call with a XID
  so the DDF agent can share locks
  with another Db2 agent that has been
  called by the stored procedure.
  

Problem conclusion

Temporary fix

Comments

• This APAR will set an XID on the RRS UR for the stored
  procedure so another Db2 agent can extract the XID and
  connect to Db2 in global transaction.
  To enable support for the XID, the user will have to define
  a DDF profile to name the stored procedure that will have
  XID set.
  This APAR provides additional changes to those provided with
  PH42395.
  

APAR Information

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

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

  UI80365

Modules/Macros

• DSNXERD  DSNRUC01 DSNRUA01 DSNXRRTN DSN3SPTN
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels