PH21103: 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 of CICS work to other data sharing members unnecessarily
  on SQLCODE -904 can cause a flood of work to other data sharing
  members.
  This is a forward fit of PI77853 to Db2 12 for z/OS.
  
  Additional Keywords:
  SQLCODE904 DB2DSHR
  

Local fix

• n/a
  

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:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  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-wide 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:

  UI67795

Modules/Macros

• DSNXERD
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI67795

     UP20/02/19 P F002

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.