A fix is available
APAR status
Closed as program error.
Error description
ABEND04E 00E2000C in DSNSVSVB OFFSET00A54 was seen, as the Db2 ADMF AGL 64 pool was full with CUB blocks. The pool was filled with approximately 516K ICUB blocks of x'400' bytes in length, allocated from module DSNICUBC OFFSET164E ( UI58987 ). Only cached dynamic statement CUBs are involved. So this is unique to release(deallocate) applications, with a low commit frequency and keepdynamic(yes). ADDITIONAL SYMPTOMS: ABEND04E RC00C90101 DSNKINSL ERQUAL500E 500E while performing an UPDATE that moves a rid to a new partition. LOOP or LOOPING in DSNICMT2
Local fix
Rebind with RELEASE(COMMIT)
Problem summary
**************************************************************** * USERS AFFECTED: All Db2 11 and 12 for z/OS users that have * * an application bound with KEEPDYNAMIC(YES) * * and RELEASE(DEALLOCATE) with low commit * * frequency. * **************************************************************** * PROBLEM DESCRIPTION: ABEND04E RC00E2000C IN DSNSVSVB * * OFFSET00A54 OR ABEND04E RC00C90101 * * in DSNKINSL ERQUAL 500E * **************************************************************** * RECOMMENDATION: * **************************************************************** When Db2 fixed the problem reported in PH01093(UI58987/UI58988), the outdated internal structures(such as cursor blocks(CUBs)) were marked invalid and the associated storage released at commit time. However, for an application with a low commit frequency, then all the invalid internal structures(such as CUBs) may stay resident in the storage pool and result in ABND=04E-00E2000C in DSNSVSVB OR ABND=04E-00C90101 in DSNKINSL occurs during cross-partition UPDATE for a partitioned tablespace.
Problem conclusion
Fixes made in Db2 to correctly invalidate the outdated internal structures only when this specific scenario is seen.
Temporary fix
Comments
APAR Information
APAR number
PH09764
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-03-14
Closed date
2019-05-30
Last modified date
2019-07-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI63329 UI63330
Modules/Macros
DSNGDCPD DSNIBCTD DSNICMTC DSNICMT2 DSNICUBC DSNIPSBL DSNIPSI DSNITCUS
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:
01 July 2019