PI71407: UTILITY MESSAGE MSGDSNU361I (FOREIGN KEY HAS NO PRIMARY KEY FOR RELATIONSHIP) ISSUED DURING LOAD OF A CHIL 16/12/30 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Utility message DSNU361I (FOREIGN KEY HAS NO PRIMARY KEY FOR
  RELATIONSHIP) issued during LOAD of a child table.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
  *                 users with PI38541 / UI41521 / UI41520       *
  *                 applied and using the LOAD utility           *
  *                 loading into a child table of a referential  *
  *                 integrity relationship.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: MSGDSNU361I during LOAD of a child      *
  *                      table with PI38541/UI41521/UI41520      *
  *                      applied.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  After applying PI38541 (UI41521/UI41520) message
  DSNU361I - 'FOREIGN KEY HAS NO PRIMARY KEY FOR
  RELATIONSHIP name' was issued during a LOAD of a child
  table in a referential integrity relationship.
  

Problem conclusion

• DB2 code has been modified to correctly build a key from a row
  in the child table to use for searching for a match in the
  index on the primary key.
  

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:

  UI43620 UI43621

Modules/Macros

• DSNIKESR DSNUCINT DSNUCLGR DSNUCRUL DSNUKINT
  DSNUKIUL DSNURCRF DSNURFBR DSNURFIT DSNURFUI DSNURLAP DSNURLXL
  DSNURPUI DSNURSCN DSNURWBF DSNURWBR DSNURWIK DSNUSTBL DSNUULXA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI43620

     UP17/01/18 P F701 Ø

• RB10 PSY UI43621

     UP17/01/18 P F701 Ø

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.