PH47804: OBJECT COMPARE SHOULD NOT REPORT PATHSCHEMAS CHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Object Compare reports PATHSCHEMAS change incorrectly when the
  source DDL has a SET CURRENT PATH statement and the
  corresponding target catalog PATHSCHEMAS column of
  SYSIBM.SYSENVIRONMENT table has the same quoted string that
  contains quoted path names as shown in the example.
  
  
  Example)
  
  
  """SYSIBM"",""SYSFUN"",""SYSPROC"",""SYSIBMADM"",""DB2ADM4"""
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare should not report a      *
  *                      PATHSCHEMAS change when the SET CURRENT *
  *                      PATH value in the DDL and the           *
  *                      PATHSCHEMAS column of the               *
  *                      SYSIBM.SYSENVIRONMENT table have the    *
  *                      same quoted PATH names.                 *
  ****************************************************************
  Object Compare should not report a PATHSCHEMAS change when the
  SET CURRENT PATH value in the DDL and the PATHSCHEMAS column of
  the SYSIBM.SYSENVIRONMENT table have the same quoted PATH name
  that includes ','.
  
  Example:
  
  Quoted PATH names in DDL:
  """SYSIBM"",""SYSFUN"",""SYSPROC"",""SYSIBMADM"",""DB2ADM4"""
  
  Erroneous logic causes Object Compare to prepend the DDL's PATH
  value with repeated SYSTEM PATH name(s) before the comparison,
  as follows:
  
  "SYSIBM","SYSFUN","SYSPROC","SYSIBMADM",""SYSIBM","SYSFUN",
  "SYSPROC","SYSIBMADM","DB2ADM4""
  
  
  Keywords: PATHSCHEMAS, SET CURRENT PATH
  

Problem conclusion

• The problem is resolved.
  
  This APAR introduces the informational message ADB7400I to
  notify users about the existing Object Compare behavior:
  
  ADB7400I Object compare prepends SYSTEM PATH names SYSIBM,
  SYSFUN, SYSPROC, and SYSIBMADM in the SET PATH statement of the
  compare source if SYSTEM PATH names are not explicitly
  specified in the compare source.
  

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:

  UI82969 UI82970

Modules/Macros

• ADB2CMS  ADB2CMT  ADB7000  ADBCDTS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI82969

     UP22/10/26 P F210

• RD10 PSY UI82970

     UP22/10/26 P F210

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.