PH66564: (GOC) OBJECT COMPARE ADDS ADDITIONAL TEXT TO COLUMN DEFINITION WHEN USING UNIQUE_COUNT IGNORE FOR SYSINDEXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• (GOC) Object Compare adds additional text to column definition
  when using UNIQUE_COUNT ignore for SYSINDEXES
  

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 improperly processes     *
  *                      include columns when the                *
  *                      SYSINDEXES:UNIQUE_COUNT                 *
  *                      ignore is specified.                    *
  ****************************************************************
  

Problem conclusion

• The problem has been resolved.
  The SYSINDEXES:UNIQUE_COUNT ignore is no longer supported.
  UNIQUE_COUNT is a vital piece of information that should not be
  ignored. If the need to ignore include columns arises, the
  INCLUDE_COLUMNS ignore exists.
  

Temporary fix

Comments

• ×**** PE25/10/09 FIX IN ERROR. SEE APAR PH68461  FOR DESCRIPTION
  ×**** PE25/10/09 FIX IN ERROR. SEE APAR PH68461  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UO03486

Modules/Macros

• GOCCIF
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RD10 PSY UO03486

     UP25/06/06 P F506

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.