A fix is available
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 number
PM75288
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
91K
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2012-10-18
Closed date
2012-12-03
Last modified date
2013-01-04
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
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":"91K","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":"91K","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 January 2013