PH08815: CM BATCH COMPARE ADD NEW COLUMN AND INDEX RECOVER CHANGE USES UNLOAD DROP CREATE AND LOAD TABLE INSTEAD OF ALTER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using CM Batch or Compare to add a new column to a table
  and to create an index referencing the new column, the
  generated recover change specifies an unload, drop, create and
  load of the table instead of an alter.
  

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 add columns with dependent indexes using *
  *                 Change Management Analyze and Recover.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When creating a Recover change          *
  *                      for an Alter that adds a new column     *
  *                      to the end of a table and creates       *
  *                      a new index on this column, the         *
  *                      reverse statements use Unload           *
  *                      Drop Create Load when an Alter          *
  *                      of the table would have been            *
  *                      sufficient.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Altering to add a new column to the end of the table and create
  a new index that refers to this new column currently results in
  an Alter in the forward path of Analyze. The Recover path,
  however, uses Unload Drop Create Load, when an Alter would
  have been sufficient.
  
  With this fix applied, the forward path of Analyze and the
  Recover path will be the same: If the change is to add a new
  column to the end of the table and create a new index that
  refers to this column, the change statements will use Alter
  to add this column. If the change is being recovered, then
  the reverse statements will use Alter to drop the column
  from the table.
  

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:

  UI63595

Modules/Macros

•    ADB2CMU
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI63595

     UP19/06/14 P F906

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.