PH67667: DROP DEPENDENT OBJECTS FOR COLUMN DROP 25/08/18 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 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.
  This APAR replaces the incorrect EXEC(ADBGAJOB) image and reship
  all parts in APAR PH66867.
  

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.
  
  This APAR replaces the incorrect EXEC(ADBGAJOB) image and reship
  all parts in the PE'd APAR PH66867.
  

Problem conclusion

• The enhancement has been delivered.
  

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:

  UO04517

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 UO04517

     UP25/08/31 P F508 {

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.