A fix is available
APAR status
Closed as program error.
Error description
DB2DDF DDFL09 DB2SNA DB2DRDA defect pm18142 dpm18142 ABND=04E-00E20002 in DSNSVBK +08C8 +09D6 ABND=04E-00E20002 in DSNRUC01 ABND=04E-00E20029 in DSNSVBK ABND=04E-00C90101 in DSNICMT2:500D the source of the overlay was an invalid remote server class name (with length of 0), ******************************************************* Additional symptoms and keywords: DVS control block trailer overlaid. SQL Get Diagnostics DB2_SERVER_CLASS_NAME SQLGETDIAG ABEND04E AB04E S004E 04E 04E-00C90101 00D90101 RC00C90101 DSNIDM DSNICMT2 DSNICMT2:500D 500D VRACE500D ERQUAL500D 04E-00E20002 00E20002 RC00E20002 DSNXEFB DSNSVBK +08C8 04E-00E20029 00E20029 RC00E20029 DSNLXREL DSNSVBK +09D6
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: All Distributed Data Facility (DDF) users. * * Specifically those using SNA network * * protocols to access remote systems. * **************************************************************** * PROBLEM DESCRIPTION: Unpredictable and intermittent abends * * may occur due to an overlay. Symptoms * * may include. * * . 04E-00C90101 DSNIDM .DSNICMT2:500D * * . 04E-00E20002 DSNXEFB .DSNSVBK +08C8 * * . 04E-00E20029 DSNLXREL.DSNSVBK +09D6 * **************************************************************** * RECOMMENDATION: * **************************************************************** A DB2 z/OS application connects to a remote location via SQL Connect. Before executing any table related SQL, the application executes an SQL Get Diagnostics to obtain DB2_SERVER_CLASS_NAME information. If the remote connection is established via SNA, the DB2_SERVER_CLASS_NAME information may be null. The incorrect null contents are not detected which may lead to a 256 byte overlay. Depending on the storage that is overlaid, unpredictable symptoms may occur.
Problem conclusion
DDF related logic has been changed to insure that the DB2_SERVER_CLASS_NAME information is properly established after an SQL Connect.
Temporary fix
Comments
APAR Information
APAR number
PM18142
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-07-09
Closed date
2010-07-22
Last modified date
2011-02-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK59008 UK59009
Modules/Macros
DSNLTCA1
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":"9.1","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":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
19 February 2011