PK27180: SQLCODE -538 REFERENTIAL INTEGRITY CONSTRAINT FOREIGN KEY IS ADDED TO CHILD TABLE BEFORE PRIMARY KEY IS ADDED TO PARENT TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Compare tool generates an apply-job which ends with sqlcode -538
  Sqlcoden538  sqlcode n538  sqlcode538
  This happens if there is a Referential Integrity constraint in
  source object but not in target object. The reason is that the
  foreign key is added to the child table before the primary key
  is added to the parent table.
  
  DSNT408I SQLCODE = -538, ERROR: FOREIGN KEY FSLD0211 DOES NOT
   CONFORM TO THE DESCRIPTION OF A PARENT KEY OF TABLE BV.TSLD021
   DSNT418I SQLSTATE   = 42830 SQLSTATE RETURN CODE
  

Local fix

• Please apply ptf when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2  OC Tool/V710                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Compare tool generates an apply-job whi *
  *                      ends with sqlcode -538.                 *
  *                      This happens if there is a Referential  *
  *                      Integrity constraint in source          *
  *                      object but not in target object.        *
  *                      The reason is that the foreign key is   *
  *                      added to the child table before the     *
  *                      primary key is added to the parent      *
  *                       table.                                 *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The foreign key is added to the child
  table before the primary key is
  added to the parent table.
  Additional fixed problem (OC V71 only)
   defect 5986 -  synonyms should
  be commented out for
  runsqlid = <none>
  

Problem conclusion

• Fixed in OC V7.1 and OC V7.2
  

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:

  UK22304

Modules/Macros

•    GOC2CMP  GOC2CMR
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK22303

     UP07/03/01 P F702

• R720 PSY UK22304

     UP07/03/01 P F702

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.