PH49335: DB2 12 AND DB2 13 FOR Z/OS NEW FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Db2 12 and Db2 13 for z/OS new function.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Db2 12 and 13 for z/OS users of singleton                    *
  * SELECTs using ISOLATION(CS)                                  *
  * CURRENTDATA(YES) but are experiencing                        *
  * excessive lock contention                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Singleton SELECTs using ISOLATION(CS)                        *
  * CURRENTDATA(YES) may encounter high                          *
  * lock contention                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Singleton SELECTs using ISOLATION(CS) CURRENTDATA(YES) may
  encounter high lock contention.  By default, lock avoidance
  techniques are not available for singleton SELECTs with
  ISOLATION(CS) CURRENTDATA(YES).  Full locking is used to
  prevent the timing issues that could result in the occasional
  false SQLCODE.  However, full locking can sometimes cause
  high lock contention.
  Additional Keywords:
  SQLCODE811 SQLCODE100
  

Problem conclusion

Temporary fix

Comments

• A new opaque subsystem parameter LA_SINGLESEL_ISOCS_CDY is
  added to allow lock avoidance for singleton SELECTs with
  ISOLATION(CS) CURRENTDATA(YES).  The valid values for this
  parameter are YES or NO.  The default is NO, meaning you
  will retain the current locking behavior.  The recommended
  setting for this parameter is NO.
  Users should be aware that by choosing YES, they could be
  subject to occasional false SQLCODEs -811 (more than one row
  returned) or +100 (no row found) for singleton SELECTs
  under ISOLATION(CS) CURRENTDATA(YES).
  

APAR Information

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

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

  UI83617 UI83618

Modules/Macros

• DSNTINMF DSNDQWPZ DSNWZIFD DSNWZIFC DSNTIDXA DSNTIVMD DSNTIJUZ
  DSNTINST DSNTIDXC DSNTIWIA DSNTIDXB DSNTIVIA DSNTIWMD DSNTIWIE
  DSNTIVIE DSNTIPM4 DSN@XAZP DSN6SPRM DSNTXAZP DSNTIWPC DSNDSPRM
  DSNTIVMN DSNTIWMN DSNTIVAF DSNTIVIN DSNXOMPS DSNTIWMS DSNXOGPS
  DSNTIVMS DSNTIWAF DSNTIWIN
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI83617

     UP22/12/21 P F212

• RD10 PSY UI83618

     UP22/12/21 P F212

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.