PI95565: DB2 ADMIN TOOL - CMBATCH IMPORT OF DROP/ADD CONSTRAINT FAILS ADBC002E RC12 - <CONSTRAINT_NAME> ALREADY EXISTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Merge erroneously issues an error message when a foreign key is
  dropped and added with the following conditions:
  1) a foreign key is dropped and added within a same change, and
  2) drop is done by ALTER TABLE ... DROP CONSTRAINT instead of
  DROP FOREIGN KEY.
  
  Job fails RC12 with error messages:
   <constraint_name> already exists
   ADBC002E - Severe error. Merge terminates
  
   ADB0006E ADBCCM ADBCCM - Error(s) found. Please review output.
   ADB7956I ADBCCM CM batch: end of CM batch.
  

Local fix

• Use DROP FOREIGN KEY instead of DROP CONSTRAINT.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS or DB2 Object Comparison            *
  *                 Tool for z/OS.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: When analyzing a change which           *
  *                      includes dropping a foreign key and     *
  *                      adding the same foreign key, Merge      *
  *                      erroneously issues error message        *
  *                      ADBC002E / msgadbc002e, and the         *
  *                      job ends with rc=12 / RC12.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Merge erroneously issues an error message when a foreign
  key is dropped and added with the following conditions:
  
  1- a foreign key is dropped and added within a same change,
  and
  
  2- a drop is done by ALTER TABLE ... DROP CONSTRAINT
  instead of DROP FOREIGN KEY.
  
  The following error messages are reported:
  
  Added foreign key fk_name for table table_name already exists
  ADBC002E - Severe error. Merge terminates
  
  Note that the first error message is split between DD REPORT
  and SYSPRINT, depending on the length of the table and the
  foreign key length.
  
  With this fix applied the error messages will not appear, and
  the job will end with RC=4.
  

Problem conclusion

• Problem has been resolved.
  

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:

Modules/Macros

•    ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI56654

     UP18/06/22 P F806

• RC10 PSY UI56655

     UP18/06/22 P F806

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.