PH66101: OBJECT COMPARE IMPROPERLY HANDLES DROPPING OF A VIEW THAT HAS CIRCULAR DEPENDENCIES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When Object Compare is dropping a view that has circular
  dependencies, Object Compare may infinitely hang, preventing
  completion. Object Compare should properly process dependencies
  to avoid any hangs. Additionally Object Compare should evaluate
  if the view can be dropped without dropping certain dependent
  objects such as procedures by utilizing REBINDs for any
  invalidated packages.
  

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 abends with USER         *
  *                      COMPLETION CODE=4088 when DROP is       *
  *                      generated for an object with            *
  *                      dependences.                            *
  ****************************************************************
  When Object Compare generates a DROP statement for an object
  with dependences and the SQL routine calls have a circular
  dependency, the job abends because of infinite recursion calls.
  Object Compare generates a DROP statement for dependent SQL
  routines when the base object is dropped. When the base object
  is a table, view, or materialized query table (MQT), it can be
  dropped without the dependent object. Object Compare needs to
  generate REBIND commands for invalidated packages instead of
  DROP statements.
  

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:

  UO03775

Modules/Macros

• ADB2CM2  ADB7000  ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO03775

     UP25/06/25 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.