PM06242: CHECK DATA UTILITY ISSUED ABEND0C4 IN DSNIMOFR IF A PARENT TABLE HAD MULTIPLE CHILD TABLES AND MIXED VERSIONED AND NOT VERSIONED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Dump Title: HD2P,ABND=0C4-00000004,U=RU99    ,M=(N),C=910.DMC
  -DSNIDNEX,M=DSNTFRCV,LOC=DSNIDM  .DSNIMOFR+7604
  Dump Title: HD2P,ABND=0C4-00000010,U=RU99    ,M=(N),C=910.DMC
              -DSNIDNEX,M=DSNTFRCV,LOC=DSNIDM  .DSNISIE2+06F4
  Dump Title: HD1P,ABND=0C4-00000010,U=RU99    ,M=(N),C=910.SMC
              -DSNSGSTG,M=DSNTFRCV,LOC=DSNSLD1 .DSNSVBK +0E2A
  CHECK DATA utility may cause ABEND0C4 in DSNIMOFR/DSNISIE2 and
  storage overlay. The storage overlay causes ABENDs in DSNSVBK.
  This happens when a parent table has multiple child tables and
  some of them are versioned and others are not versioned.
  After a down level row in a versioned child table was processed
  unnecessary conversion happened on a row in a non-versioned
  child table.
  The incorrect conversion caused storage overlay.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 z/OS users of CHECK                  *
  *                 DATA or LOAD utility.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Down level version flag doesn't get     *
  *                      reset when processing mixed versioned   *
  *                      child tables under the same parent for  *
  *                      RI cascade delete.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  During a referential integrity cascade delete operation, the
  CHECK DATA or LOAD utility will delete a specific error record
  (root record) followed by deleting all of its dependent
  records.
  If the parent table has multiple child tables, some of the
  internal control block will be updated to the next dependent,
  but it is missing to update the down level version flag
  and cause the storage overlay.
  

Problem conclusion

• Code has been changed to ensure reset the down level version
  flag when processing next dependent table.
  

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:

  UK57956 UK57957

Modules/Macros

• DSNIDNEX
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK57956

     UP10/06/30 P F006

• R910 PSY UK57957

     UP10/06/30 P F006

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.