PH66867: DROP DEPENDENT OBJECTS FOR COLUMN DROP

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Drop dependent objects for column drop
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR enhances the Object Compare   *
  *                      processing for columns that are dropped *
  *                      from a table.                           *
  ****************************************************************
  Object Compare checks Db2 restrictions for generating a DROP
  COLUMN statement. If it cannot be generated, Object Compare
  issues message ADB7191I or ADB7192I and drops and re-creates the
  table to drop a column.
  This APAR removes some of the reasons for the ADB7191I and
  ADB7192I messages. Dependent objects that prevent the execution
  of a DROP COLUMN statement will be dropped and re-created to
  allow the ALTER on the table.
  This APAR removes the following restrictions:
   - The column is referenced by a unique constraint.
   - The column is referenced by a referential constraint.
   - The column is referenced by views or triggers.
   - The table has check constraints.
   - The table has a validation exit procedure.
   - The table is referenced by row permissions or column masks.
   - INSTEAD OF triggers are defined on a view that is dependent
  on the table.
   - The table is referenced by extended indexes or inline SQL
  table functions.
   - The table is referenced by materialized query tables.
  

Problem conclusion

• The enhancement has been delivered.
  

Temporary fix

Comments

• ×**** PE25/07/15 FIX IN ERROR. SEE APAR PH67351  FOR DESCRIPTION
  ×**** PE25/08/18 FIX IN ERROR. SEE APAR PH67667  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UO03581

Modules/Macros

• ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS
  ADB2CMT  ADB2CMU  ADBGAJOB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO03581

     UP25/06/12 P F506  

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.