A fix is available
APAR status
Closed as program error.
Error description
The problem occurs for an XML insert to its history temporal table. ABEND S04E RC00E2000C in DSNSVSVB+00A54 because a storage leak issue where the XML thread eats out 2531328K long pool storage. Too many XML insert CUBs are created by DSNNOIRT and eat out the thread's storage long pool.
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 11 for z/OS and Db2 12 for z/OS * * users of temporal table with XML column. * **************************************************************** * PROBLEM DESCRIPTION: * * ABEND04E RC00E2000C IN * * DSNICUBD.DSNSVSVB OFFSET00A54 * * occurred during XML insert processing. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** During XML insert, DM would perform an insert to a temporal table with XML column. When processing inserts to the temporal table, XML created an XML CUB block to perform the insert, which was not freed. Too many CUBs caused storage pool reaching the limit, then caused abend at DSNICUBD.DSNSVSVB +x?00A54?.
Problem conclusion
Db2 has been modified to free CUBs after INSERT finished.
Temporary fix
Comments
APAR Information
APAR number
PH24301
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-04-10
Closed date
2020-06-25
Last modified date
2020-08-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI70272 UI70273
Modules/Macros
DSNNOIRT
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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
05 August 2020