PH36351: CHECK DATA UTILITY ISSUES MSG DSNU729I FOR EXCLUDED DEFINE NO UNDERLYING VSAM DSNS) OBJECTS INVOLVED IN RI RELATIONSHIP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DEFINE NO objects involved in a RI relationship - with no
  underlying VSAM files - are excluded by Automation Tool when
  generating CHECK DATA objects. This results in the CHECK DATA
  utility issuing the following Db2 message:
  
  DSNU729I csect-name TABLE table-name NOT SPECIFIED IN THE 'FOR
  EXCEPTION' CLAUSE
  

Local fix

• To avoid the above issue, customers will need to do the
  following:
  
  1) Edit their CHECK DATA utility profile via panel HAA$UCHK
  2) New field "Include Implicit spaces" - set value to "Y"
  3) save the CHECK DATA utility profile
  4) rerun the BUILD
  
  The Build should now include all implicitly defined spaces
  required for CHECK DATA.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: DEFINE NO objects involved in a RI      *
  *                      relationship - with no underlying VSAM  *
  *                      files - are excluded by Automation Tool *
  *                      when generating CHECK DATA objects.     *
  *                      This results in the CHECK DATA utility  *
  *                      issuing the following Db2 message:      *
  *                                                              *
  *                        DSNU729I csect-name TABLE table-      *
  *                        name NOT SPECIFIED IN THE 'FOR        *
  *                        EXCEPTION' CLAUSE                     *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF                                *
  ****************************************************************
  .
  

Problem conclusion

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:

  UI76292

Modules/Macros

• HAA#BPRI HAA#BSQL HAA#OBEX HAA#RI   HAA#RIX  HAA#UPRI HAA#UTED
  HAA#UTOB HAA#UTOP HAA$BULD HAA$BUTK HAA$CALL HAA$DS   HAA$SINF
  HAA$UCHK HAA$UCHX HAA$UOPT HAAEXCTC HAAHUCHK HAAHVCHK
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R430 PSY UI76292

     UP21/07/16 P F107

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.