A fix is available
APAR status
Closed as program error.
Error description
ABEND04E RC00E20015 from DSNSVSTK Or ABEND04E RC00E20013 from DSNSGMN ABEND04E RC00E20003 maybe possible. Storage was filled with AIDL allocated by DSN3AUCN. DB2STGLK/K
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All users of DB2 UDB for z/OS Version 9 * * ODBC/CLI and DB2 10 for z/OS ODBC/CLI. * **************************************************************** * PROBLEM DESCRIPTION: ODBC applications running with external * * contexts may experience excess * * DSN3201I messages being reported * * causing storage leaks in DB2. * **************************************************************** * RECOMMENDATION: * **************************************************************** ODBC application running with MVSATTACHTYPE=RRSAF and MULTICONTEXT=0 can use the z/OS Resource Recovery Services (RRS) to create and manage its own RRS private contexts outside of DB2 ODBC. All connection handles allocated under a RRS private context share a single DB2 thread which must be terminated when the last connection handle in the context is deallocated. However, if the DB2 thread is not terminated, this will result in DSN3201I message being issued when the application ends.
Problem conclusion
Code has been modified to terminate attachment to DB2 if the connection handle being deallocated is the last connection in the RRS context for the current task.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM68459
Reported component name
DB2 ODBC/JDBC/S
Reported component ID
5740XYR02
Reported release
A17
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-07-09
Closed date
2012-08-10
Last modified date
2012-09-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK81020 UK81021
Modules/Macros
DSNAOCLI DSNAOC02 DSNAOG02 DSNAOSDK
Fix information
Fixed component name
DB2 ODBC/JDBC/S
Fixed component ID
5740XYR02
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A17"}]
Document Information
Modified date:
04 March 2021