PM12052: VIEW NOT DROPPED AS EXPECTED WHEN CHANGE MANAGEMENT METHOD USED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS does not drop a view
  dependent on another view when the Change Management option
  is used even though the job output shows:
     Suppress DROP of objects  : No
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object                      *
  *                 Comparison Tool for z/OS                     *
  *                 who compare views.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison               *
  *                      Tool does not drop a view               *
  *                      dependent on another view               *
  *                      when the Change Management              *
  *                      option is used.  The DB2 Object         *
  *                      Comparison Tool does not drop           *
  *                      a view alias when both view and         *
  *                      alias are on the target only.           *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The DB2 Object Comparison Tool does not drop a
  view dependent on another view when the Change
  Management option is used.  The DB2 Object
  Comparison Tool does not drop a view alias when both
  view and alias are on the target only.
  

Problem conclusion

• The DB2 Object Comparison Tool has been updated
  to drop the dependent view from the target if the view
  is not on the source and the Change Management
  option is used. The DB2 Object Comparison Tool will
  drop an alias on a view if the alias is on the target only.
  

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:

  UK59209

Modules/Macros

•    GOC2CMP  GOC2CMR
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK59209

     UP10/07/30 P F007

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.