A fix is available
APAR status
Closed as program error.
Error description
Growth of DBM1 MVS 31 BIT HIGH PRIVATE, for scenarios where there is insert / update / delete and RLF / RLST used. Additional Symptoms: ABEND0C4 RC00000010 DSNTGSCC DSNTCSRQ OFFSET00DD6 ABEND04E RC00E30001 DSNTGSCC DSNTCSRS OFFSET039EA ABEND0C4 RC0000003B DSNTGSCC DSNTCSRQ OFFSET00CB6 Keywords: SQLCGTT DB2RLF
Local fix
If customer only has RLST table, then creating an empty RLMT table with the same ID as the RLST table will help workaround the problem.
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS users of * * -STA RLIMIT SCOPE(GROUP) command * **************************************************************** * PROBLEM DESCRIPTION: * * Growth of DBM1 MVS 31 BIT HIGH PRIVATE * * for scenarios where there is * * insert / update / delete on a * * created temporary table and * * RLF is active. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** After RLF is started with only either the RLST or the RLMT table (not both), an INSERT, UPDATE or DELETE on a created temporary table may invoke unnecessary internal refresh of the in-memory RLF table. This refresh process runs on on a Db2 system thread and too many of them can cause the storage growth.
Problem conclusion
Db2 code has been changed to invoke the refresh process of the in-memory RLF table correctly. Only when the based RLST or RLMT table is updated, the auto refresh of in-memory RLF table is started. Additional Keywords: SQLCGTT DB2RLF
Temporary fix
Comments
APAR Information
APAR number
PH13940
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
2019-07-01
Closed date
2019-09-17
Last modified date
2019-11-26
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI65356
Modules/Macros
DSNXERT
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI65356
UP19/10/04 P F910
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":"12.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":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
26 November 2019