PH34847: DB2 OBJECT COMPARE: MULTIPLE ONCODE 150 STATEMENTS AND ADB7184E

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 Object Compare: Multiple ONCODE 150 statements and ADB7184E
  
  During a compare, ADB7184E A duplicate record was detected for
  object 'object name' followed by multiple ONCODE = 150
  
  Also it is possible to see ADB7380E Severe Error with no
  explanation.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Object Comparison Tool for      *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare fails when processing    *
  *                      DDL with foreign keys.                  *
  ****************************************************************
  When doing a comparison from source or target DDL,
  the comparison might fail when processing foreign keys.
  For example:
  
  Foreign key for table USER.TABLE1 to table USER.TABLE2 not found
  on target Column list is : (COL1, COL2, COL3, COL4)
    New Foreign key for table USER.TABLE1 will be added
  ADB7116E No match to the child column was found in the
    corresponding parent table.
  
  In this example, Object Compare did not properly process DDL
  with foreign keys in the CREATE TABLE statement, combined with
  an ALTER TABLE statement to add a self-referencing foreign key.
  

Problem conclusion

• The problem has been resolved.
  
  Search keywords: MSGADB7116 MSGADB7116E
  

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:

  UI75093

Modules/Macros

• ADBCDTS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI75093

     UP21/04/28 P F104

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.