PH69072: DROP IMPACT REPORT FOR DEPENDENT OBJECTS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Drop impact report for dependent objects.
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR adds support for the drop     *
  *                      impact report to include dependent      *
  *                      objects that prevent the drop.          *
  ****************************************************************
  The drop impact report shows the list of objects that will be
  dropped when a DROP statement is executed. But for some
  object types (such as SQL functions), dependent objects can
  prevent the execution of a DROP statement so they must be
  dropped before the DROP statement execution.
  With this APAR, dependent objects are displayed on the 'DROP
  Impact Analysis Details' panel (ADB2DIPD) with the comment
  'Dependent'. New primary command DROPDEP allows you to drop
  dependent objects that prevent a DROP. New primary command
  GENDEP generates a GEN job to generate the SQL to re-create
  dependent objects.
  

Problem conclusion

Temporary fix

Comments

• The enhancement has been delivered.
  

APAR Information

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

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

  UO05971

Modules/Macros

• ADB2DIP  ADB2DIPD ADB2GENB ADBHDIPD
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO05971

     UP25/11/27 P F511  

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.