A fix is available
APAR status
Closed as program error.
Error description
DB2DDF DB2TCPIP Db2 for z/OS message DSNL511I SOCKET=RECV RETURN CODE=1121 REASON CODE=769E0291 may be seen in a z/OS V2R3 environment when an application ends before the connection is closed. No application error is reported, the DSNL511I messages may be numerous. There is no impact to the application. The problem occurs in a z/OS V2R3 environment only because Communications Server V2R3 APAR PI32425 introduces a new reason code that is returned to Db2 during the connection reset scenario described. In a z/os environment lower then z/OS V2R3, the DSNL511I message may have been seen with a reason code=0000. If Db2 APAR PM37030 is applied in that environment, the DSNL511I message will be suppressed for the described case. *************************************************************** Additional Symptoms and Keywords: DSNL511I MSGDSNL511I RECV 1121 RC1121 ECONNRESET 769E0291 RC769E0291 0291 JrTcpError
Local fix
no local workaround/fix
Problem summary
**************************************************************** * USERS AFFECTED: All Distributed Data Facility (DDF) users. * * Primarily those who have migrated their * * systems to z/OS Version 2 Release 3 (V2R3). * **************************************************************** * PROBLEM DESCRIPTION: Numerous occurrences of message * * DSNL511I being issued with tokens: * * - SOCKET=RECV * * - RETURN CODE=1121 * * - REASON CODE=769E0291 * **************************************************************** * RECOMMENDATION: Apply corrective PTF when available. * **************************************************************** Communications Server (CS) for z/OS V2R3 included a solution for APAR PI32425 such that a valid non-zero reason code (errnojr) would now be provided when an asyncio request returns a non-zero return code. The errnojr being returned when an asyncio receive request gets a RETURN CODE=1121 (ECONNRESET) error is now 0291 (JrTcpError). Prior to CS for z/OS V2R3, a zero reason code was returned. Prior to the availability of z/OS V2R3, Db2 provided APAR PM37030 which suppressed DSNL511I messages when an asyncio receive for a distributed client connection resulted in an ECONNRESET REASON CODE=00000000 condition and Db2 was not currently processing a transaction for the connection. With the change made to CS for z/OS V2R3, an asyncio would now receive REASON CODE=769E0291E relative to an ECONNRESET condition and Db2 would therefore no longer suppress the DSNL511I message. There is no remote application error despite the renewed presence of the DSNL511I message in z/OS V2R3 environments.
Problem conclusion
Db2 has been changed to suppress message DSNL511I if it receives an ECONNRESET error with REASON CODE=769E0291 and Db2 is not currently processing a transaction for the distributed client connection. However, the message will continue to be issued if it is received while a transaction is still in progress.
Temporary fix
Comments
APAR Information
APAR number
PH04763
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-10-31
Closed date
2018-12-14
Last modified date
2019-01-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI60282 UI60284
Modules/Macros
DSNLIENO
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"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":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 January 2019