PH13940: INSERT / UPDATE / DELETE ON CGTT MAY INVOKE UNNECESSARY INTERNAL START RLIMIT AND STORAGE LEAK. RLF ENABLED

Obtain the fix for this APAR.

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 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.