PM89918: STALE CONNECTION ERROR FOLLOWING A TIMEOUT AND DEADLOCK AFTER UPGRADING THE JDBC DRIVER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The JDBC Driver makes a call to DB2 through CICS.  Following
  this call to DB2, JDBC is passed back a Non-zero return code in
  Register 15. This causes the JDBC driver decides that the
  connection is lost.
  
  The non-zero code in R15 is a 4, indicating a UERFDONE, which
  is returned after a successful backout. Trace shows that the
  region is running with  DROLLBACK=YES. The UERFDONE should not
  be passed back to the JDBC driver, since the driver is not who
  initiates the SYNCPOINT. CICS should not percolate back to the
  UERFDONE setting from the syncpoint rollback call. This results
  in the SQLCODE -4499, indicating a stale connection error.
  
  Additional Symptom(s) Search Keyword(s): KIXREVNDB -924 ,
  LOT_RMI_RETURN_CODE , LOT_RMI_RETURN_CODE_OK
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All.                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Using the JDBC driver to call DB2 in    *
  *                      CICS it is possible to receive an       *
  *                      SQLCODE -4499, indicating a stale       *
  *                      connection error.                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A transaction uses the JDBC driver to call DB2 in CICS and does
  a successful backout. A return code of UERFDONE is passed back
  to the JDBC driver. Because UERFDONE is non-zero (4) the JDBC
  driver believes the connection is lost and this results in an
  SQLCODE -4499, indicating a stale connection error.
  
  Keyword: SQLJ
  

Problem conclusion

• DFHD2EX1 has been changed to ensure the UERFDONE return code is
  not being percolated back to the JDBC driver.
  

Temporary fix

• FIX AVAILABLE BY PTF ONLY
  

Comments

APAR Information

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

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

  PM96536 UK98227

Modules/Macros

•    DFHD2EX1
  

Fix information

• Fixed component name

  CICS TS Z/OS V4

• Fixed component ID

  5655S9700

Applicable component levels

• R700 PSY UK98227

     UP13/10/13 P F310

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.