A fix is available
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 number
PM89918
Reported component name
CICS TS Z/OS V4
Reported component ID
5655S9700
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-05-28
Closed date
2013-09-23
Last modified date
2013-11-04
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.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGMGV","label":"CICS Transaction Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.2","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.2","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 November 2013