PH06862: DB2 ADMIN TOOL - MOVING COLUMN FROM INDEX INCLUDE LIST INTO INDEX KEY CREATES DUPLICATE INDEX KEYS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After removing a column from the INCLUDE clause and adding it
  to the index key list, the Compare job using CM batch interface
  generates the removed column twice in target index key list.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS or Db2 Object Comparison Tool for       *
  *                 z/OS who compare indexes.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Compare generates CREATE INDEX          *
  *                      statement with duplicate index key      *
  *                      columns which leads to SQLCODE=-612 /   *
  *                      SQLCODEN612.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Compare generates CREATE INDEX statement with duplicate index
  key columns. The problem occurs with a change that leads to
  the replacement of index key columns and the index key has the
  same column used in the INCLUDE option. Applying the change
  results in an error SQLCODE -612 >column name< IS A
  DUPLICATE NAME.
  

Problem conclusion

• Problem 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:

  UI62303

Modules/Macros

•    ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI62303

     UP19/04/05 P F904

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.