PI44403: DB2 ADMINISTRATION TOOL FOR Z/OS PRODUCES INCORRECT CREATE INDEX WHEN ALTER INDEX WITH EXPRESSION TO ADD COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS produces incorrect create
  index when Alter Index with Expression to add column
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'ALT Redefine an Index'     *
  *                 (ALT) command on an index with an            *
  *                 Expression.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Administration Tool for z/OS        *
  *                      produces an incorrect CREATE INDEX      *
  *                      statement in the change file which      *
  *                      is missing some of the original         *
  *                      columns when performing an ALT on       *
  *                      an index with an Expression to add      *
  *                      an additional column.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Administration Tool for z/OS produces an incorrect CREATE
  INDEX statement in the change file which is missing some of the
  original columns when performing an ALT on an index with an
  Expression to add an additional column.
  

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:

  UI31552

Modules/Macros

• ADB21XA0
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI31552

     UP15/10/01 P F509

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.