PH65807: 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

• When using a UNIQUE_COUNT ignore for SYSINDEXES, Object Compare
  mistakenly adds additional text to ALTER INDEX ADD COLUMN
  statements. This additional text makes the change incomplete and
  can lead to errors. Object Compare should properly generate the
  statements when using the ignore.
  

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.                    *
  ****************************************************************
  When Object Compare processes a unique index and the
  SYSINDEXES:UNIQUE_COUNT ignore is specified, include columns are
  not properly compared. This behavior results in incorrect ALTER
  statements being generated for the columns.
  

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/02 FIX IN ERROR. SEE APAR PH68382  FOR DESCRIPTION
  ×**** PE25/10/02 FIX IN ERROR. SEE APAR PH68382  FOR DESCRIPTION
  

APAR Information

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

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

  UO03485

Modules/Macros

• ADB2CME  ADB2IGN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO03485

     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.