PH17310: DB2 ADMIN TOOL : COMPARE REPORTING ON SYNONYMS THAT DO NOT EXIST

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• During a compare a message is issued that states
  'Processing Synonym ' schema.name
  
  Followed later by
  
  'ADB1609W Synonym' schema.name 'not found'
  
  The source DDL has no synonyms, so these messages should
  not be displayed.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Object Comparison Tool for  *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When comparing a table, compare will    *
  *                      automatically check the catalog for the *
  *                      existence of a synonym and alias of the *
  *                      same name. This results in warnings on  *
  *                      objects not present in the source.      *
  *                                                              *
  *                      For example: If a table exists, A.T1,   *
  *                      you may see messages like:              *
  *                                                              *
  *                      Processing Table/View/Alias A.T1        *
  *                      Processing Synonym A.T1                 *
  *                      ADB1609W Alias A.T1 not found           *
  *                      ADB1609W Synonym A.T1 not found         *
  ****************************************************************
  When comparing a table, compare will automatically check the
  catalog for the existence of a synonym and alias of the
  same name. This results in warnings on objects not present in
  the source.
  

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:

  UI66932

Modules/Macros

• ADB0     ADBCVOC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI66932

     UP19/12/25 P F912

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.