A fix is available
APAR status
Closed as program error.
Error description
A Storage leak could occur while running driver packages with incorrect clientApplcompat setting. In this case, the problem comes up while running an old driver and its JCC Package rebound with APPLCOMPAT(V12R1M501). It could also occur when using a newer driver if clientApplcompat property is set higher than what the Package is bound with. As external symptom was observed: DSNT500I -DB2 DSNGEPLC RESOURCE UNAVAILABLE REASON 00C90089 TYPE 00000605 NAME EDM RUNTIME ABOVE SPACE After analyzing the dump it turned out that ADMF AGL V64 PHB storage pool was filled by thousands of DSNGEGFB Control Blocks with eyecatcher EDMP. ADDITIONAL SYMPTOMS: SQLSTORAGE DB2STGLK/K
Local fix
BYPASS/CIRCUMVENTION: A possible workaround is to bind the Packages with APPLCOMPAT V11R1. In general, workaround is to upgrade the driver and set clientApplcompat to a value lower than or equal to the Packages.
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS users of remote SQL * **************************************************************** * PROBLEM DESCRIPTION: * * STORAGE LEAK WHILE RUNNING DRIVER * * PACKAGES WITH INCORRECT * * CLIENTAPPLCOMPAT SETTING * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** A Storage leak could occur while running driver packages with incorrect clientApplcompat setting. In this case, the problem comes up while running an old driver and its JCC Package rebound with APPLCOMPAT(V12R1M501). It could also occur when using a newer driver if clientApplcompat property is set higher than what the Package is bound with. As external symptom was observed: DSNT500I -DB2 DSNGEPLC RESOURCE UNAVAILABLE REASON 00C90089 TYPE 00000605 NAME EDM RUNTIME ABOVE SPACE After analyzing the dump it turned out that ADMF AGL V64 PHB storage pool was filled by thousands of control blocks with eyecatcher EDMP. Prior to the abend, these remote applications receive SQLCODE -30025. When this occurs, the package storage is allocated in the agents private storage, above-the-bar storage pool, but it is not freed.
Problem conclusion
Db2 is modified to free the package storage when the clientapplcompat check fails. ADDITIONAL SYMPTOMS: SQLSTORAGE DB2STGLK/K SQLCODE30025
Temporary fix
Comments
APAR Information
APAR number
PH41055
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
YesPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-10-04
Closed date
2021-12-27
Last modified date
2022-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI78742
Modules/Macros
DSNXEPM
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI78742
UP22/01/05 P F201
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":"12.0"}]
Document Information
Modified date:
02 February 2022