PH65329: UDF ON VIEW IS NOT RECREATED AFTER BASE TABLE DROP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Inline SQL table functions that depend on the view are not
  recreated if view is not changed but drop/created due to the
  drop/create of the base table of the view.
  

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 does not detect an       *
  *                      implicit drop of an inline SQL table    *
  *                      function dependent on the view.         *
  ****************************************************************
  Object Compare does not recreate an implicitly dropped inline
  SQL table function dependent on the view if the view is
  implicitly dropped by the drop of the base table.
  

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:

  UO02678

Modules/Macros

• ADB2CMP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO02678

     UP25/04/03 P F504

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.