PH44269: DROP REPORT IMPACT INCOMPLETE - NOT SHOWING DEPENDENT FUNCTION

APAR status

• Closed as program error.

Error description

• When doing a drop of a view with Drop Impact Report = yes
  specified, the report does not show the dependent SQL scalar
  function.
  
  ADDITIONAL SYMPTOMS:
   When doing a drop of a view with Drop Impact Report = yes
  specified, the report does not show the dependent SQL scalar
  function.
  

Local fix

• BYPASS/CIRCUMVENTION:
  na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When issuing the DROP line command on a *
  *                      view that is referenced in the body of  *
  *                      an SQL function, a requested drop       *
  *                      impact report does not correctly show   *
  *                      that the SQL scalar function will be    *
  *                      dropped.                                *
  ****************************************************************
  On panel ADB21T, the user issued a DROP line command on a view.
  This view is listed in the SQL body of an SQL function. On Drop
  panel ADB26DT, if REPORT DROP IMPACT is specified as YES, the
  report does not show the function as it should.
  

Problem conclusion

• The 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:

  UI80430

Modules/Macros

• ADB2GEN  ADB2GEN2 ADB2GENB ADB2REP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels