PH57615: OBJECT COMPARE INCORRECTLY GENERATES THE CHECK DATA AFTER FIRST FOREIGN KEY CHANGE, LEADING TO SQLCODE = -20385

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When doing multiple foreign key changes, Object Compare
  incorrectly generates CHECK DATA after the first ALTER FOREIGN
  KEY for a table. This can lead to a SQLCODE = -20385 when doing
  a destructive change later down the line as the table space is
  in check pending from the subsequent ALTER FOREIGN KEY
  statements. Object Compare should generate the CHECK DATA after
  the last ALTER FOREIGN KEY statement for a table to avoid the
  SQLCODE = -20385
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare incorrectly generates    *
  *                      a CHECK DATA utility statement after    *
  *                      the first foreign key change, resulting *
  *                      in SQLCODE = -20385.                    *
  ****************************************************************
  When doing multiple ALTER FOREIGN KEY operations and either a
  ALTER TABLE DROP COLUMN or ALTER TABLE ALTER PARTITION
  operation on a table, Object Compare incorrectly generates the
  required CHECK DATA operation after the first foreign key change
  instead of after the last one in the set. This behavior causes
  the table space to be placed in CHECK-pending status before the
  ALTER TABLE statements, resulting in SQLCODE = -20385.
  

Problem conclusion

• The problem has been fixed. Object Compare will generate the
  required CHECK DATA operation after the last foreign key change
  in order for the table space to be ready for the ALTER TABLE
  statements.
  

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:

  UI95241 UI95242

Modules/Macros

• ADB2CMF
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI95241

     UP24/01/18 P F401

• RD10 PSY UI95242

     UP24/02/01 P F401

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.