PH14708: DB2 ADMIN. TOOL - ERROR WHEN ADDING A COMMENT TO A VIEW

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Error occurs when adding a comment to a view:
  
  ADB8052E A change was found for <object name> but no base
           definition was found.
  ADB8068I Partial statement at the point of error:
           COMMENT ON TABLE <object name> IS
           'Relation/Arrangement Relationship Xchange View'
  
  ADB8057I Object details at the time of error:
               Operation       : 306
               Row type        : YX
               Object qualifier: <schema name>
               Object name     : <object name>
               Procedure       : merge_files
  

Local fix

•  n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool for Z/OS *
  *                 who comment on views.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Merge results in error: ADB8052E when   *
  *                      changing a comment on a view. The       *
  *                      resulting WSL from analyze does not     *
  *                      include the DDL for changing the        *
  *                      comment on the view.                    *
  ****************************************************************
  Merge is given incorrect information because of the DDL produced
  for a change to a comment on a view. The alter on a view is
  mistaken for an alter on a table. Merge results in error:
  ADB8052E. Once past this issue the resulting WSL fails to
  contain the change to the comment on the view.
  

Problem conclusion

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

  UI65734

Modules/Macros

• ADB2CMP  ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI65734

     UP19/10/10 P F910

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.