PH64378: INCORRECT PROCESSING OF DROP VIEW THAT HAS ALIAS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When running COMPARE to create the drop statement of the
  database and all its objects, the job ends with rc=8 and message
  "ADB7955E ADB2CM2 GOC2CMP - Error(s) found. Please review
  output. When isolating the error, a view is the reason.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Change Management analyze job fails *
  *                      to drop a view that has aliases.        *
  ****************************************************************
  When Change Management processes the DROP statement for a
  view that has aliases, the analyze job can fail with RC=8 and no
  specific error messages if view aliases are not dropped. The
  analyz ereport shows that a view alias is not found on the
  source and that an alias with the same name is not found on
  the target.
  

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:

  UO02399

Modules/Macros

• ADB2CMR  ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO02399

     UP25/03/13 P F503

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.