PI52967: TRANSACTION GETS SQLCODE -904 WITH ZPARM RETLWAIT = 1

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 data sharing environment.
  ZPARM RETLWAIT=1 (RETAINED LOCK TIMEOUT) is set.
  As the 'retained lock timeout' zparm is set, it's expected that
  a transaction waits until an incompatible retained lock is
  purged, or timed out when the member holding the lock is
  abnormally terminated.
  However some transactions don't wait for the retained lock and
  fail immediately with sqlcode -904 . Sqlcode -911 is expected
  instead.
  Example of -904 from the scenario. Index access required.
  DSNT408I SQLCODE = -904,
          ERROR:  UNSUCCESSFUL EXECUTION CAUSED BY AN
          UNAVAILABLE RESOURCE. REASON 00C900BE, TYPE OF RESOURCE
          00000304, AND RESOURCE NAME
          xxxDB   .xxxxTS  .X'00000002'.X'01'
                                                                 .
  Additional keywords: rc00c900be
                       srcn904
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
  *                 users using indexes.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Unexpected SQLCODE904 issued for SELECT *
  *                      statement using index access.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Unexpected SQLCODE904 issued for SELECT statement that failed
  to detect retained lock held by a subsystem that was down and
  retained lock timeout field (RETLWAIT) had non-zero value.
  
  Additional Keywords: SQLLOCK, SQLCODE904, SQLCODE911
  

Problem conclusion

• DB2 has been modified to honor retained lock timeout
  field (RETLWAIT).
  

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:

  UI34908 UI34909

Modules/Macros

• DSNKFLRR DSNKFLST DSNKFPRV DSNKFTCH DSNKFTRR
  DSNKNXT2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI34908

     UP16/02/16 P F602

• RB10 PSY UI34909

     UP16/02/16 P F602

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.