PM75288: ABEND 04E 00E20005 IN A DELETE WHEN IT EXECUTES CASCADE DELETE AND THE CHILD TABLE HAS A DELETE TRIGGER.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After cascade delete, ABEND04E RC00E20005 happened when RWA(4)
  was freed because its storage manager trailer was overlaid.
  In cascade delete process, if the child table has a delete
  trigger, it obtains a RWA for the transition table.
  It may take shorter length RWA and cause overlay of the storage
  manager trailer.
  Its overlay caused ABEND04E RC00E20005 when the RWA was freed.
  
  Additional Keywords: SMCOVERLAY DB2OVRLAY/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 9 and 10 for z/OS users of cascade       *
  *                 delete rule, where there is after delete     *
  *                 trigger on dependant table.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E2005 when DSNITDLE tries  *
  *                      to free a work area during a delete to  *
  *                      parent table.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  During cascade delete process against a child table, if the
  child table has After Delete trigger defined and the trigger
  refers to an old transition table or variable, a work file
  could be created on the fly if the total size of deleted records
  of the child table was larger than a certain threshold.
  If the child table has columns of type LOB or ROWID, internal
  working area for the work file was not allocated with adequate
  size. As a consequence, an overlay might happen while moving
  transition records from the work file to the working area.
  

Problem conclusion

• DB2 code is fixed to make sure working area is allocated with
  adequate size for transition record from the work file.
  

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:

  UK83963 UK83964

Modules/Macros

•    DSNIATPR DSNILTTV DSNITCU
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK83963

     UP12/12/19 P F212

• R910 PSY UK83964

     UP12/12/19 P F212

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.