PI77853: ROUTING CICS WORK TO DATA SHARING MEMBERS UNNECESSARILY ON SQLCODE904

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Routing CICS work to data sharing members unnecessarily
  on SQLCODE904 .
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Db2 for z/OS users with CICS transactions    *
  *                 in a data sharing environment                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Upon a resource unavailable condition   *
  *                      (an SQLCODE -904)                       *
  *                      for an SQL request from a CICS          *
  *                      transaction, Db2 invokes z/OS Workload  *
  *                      Balance Manager to route the subsequent *
  *                      work to another data sharing member.    *
  *                      Such routing is unnecessary and can     *
  *                      cause flooding of works to other        *
  *                      members in the data sharing group.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When an SQL request from a CICS connection results in a
  resource unavailable condition (an SQLCODE -904), Db2 also
  invokes a WLM service to route further work to other members in
  the data sharing group. Such routing may not be necessary since
  there is no guarantee the unavailable condition will be
  resolved when the SQL request is run on another member. On the
  other hand, that routing may cause flooding of work to other
  members and result in group-wise failure.
  

Problem conclusion

• Db2 has been changed to no longer route CICS works to another
  data sharing member on a resource unavailable condition on
  an SQL request.
  
  Additional keywords: SQLCODE904 DB2DSHR
  

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:

  UI54152

Modules/Macros

•    DSNXERD
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI54152

     UP18/03/16 P F803

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.