PK35962: OBJECT COMPARE LOOP WHEN USING MASK THAT CAUSES SOME OBJECTS TO HAVE DUPLICATE NAMES AND ALIAS IS ALSO FOUND AS A VIEW

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using Object Compare loops when using mask that causes this msg
  Warning : Some objects have duplicate names after masking or
           other name change
  
    Alias   SLDE.VSLDUS2 is also found as a View
    Alias   SLDE.VSLDUS1 is also found as a View
   When resolving views, sequence is : 1) Tables 2) Views 3)
    3) Synonyms and4) Aliases
  
  To circumvent the loop do not use the Mask .
  

Local fix

• Please apply ptf when available
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool, who     *
  *                 use masking, may be affected.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object  Compare  loops  when using MASK *
  *                      that   causes   some  objects  to  have *
  *                      duplicate   names   and  ALIAS  is also *
  *                      found as a VIEW.                        *
  *                      .*                                      *
  *                      Object  Compare  loops  when using MASK *
  *                      that causes this message - Warning :    *
  *                      Some objects have duplicate names after *
  *                      masking or other name change.  An Alias *
  *                      is also found as a View.                *
  *                      .* Note:                                *
  *                      The looping problem has been fixed.     *
  *                      .* Note                                 *
  *                      The  warning  message  mentioned in the *
  *                      problem description is correct. Masking *
  *                      of  all object names from the source to *
  *                      the target is intentional.The qualifier *
  *                      of the view  has been  masked to be the *
  *                      same as the qualifier of the alias. And *
  *                      since  view name and alias name are the *
  *                      same,  the  qualified   names  of  both *
  *                      objects therefore become identical.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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:

Modules/Macros

•    GOC2CMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK21799

     UP07/02/06 P F702

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.