PK39167: "SMART" ALTER NOT PERFORMED WHEN OPTION, "SUPPRESS DROP OF COLUMNS" SELECTED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Comparison Tool not generating "SMART" Alter when
  using "Suppress Drop of Column" option during compare
  processing.  Source Table has new columns, but Target
  Table has additional columns not found on Source Table.
  Additional columns found on Target subsystem were kept
  when using "Suppress Drop of Column" option.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Object Compare V71 and V72.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: DURING COMPARE PROCESSING "SMART" ALTER *
  *                      WAS NOT SELECTED WHEN OPTION "SUPPRESS  *
  *                      DROP OF COLUMNS" WAS IN EFFECT, ALONG   *
  *                      WITH AN EXTRA COLUMN IN THE TARGET DDL. *
  *                      WHEN THE EXTRA COLUMN IN THE TARGET DDL *
  *                      IS REMOVED, "SMART" ALTER IS SELECTED.  *
  *                      THE PURPOSE OF THE "SUPPRESS DROP OF    *
  *                      COLUMNS" IS TO KEEP TARGET COLUMNS AND  *
  *                      ADD NEW COLUMNS FROM SOURCE USING       *
  *                      "SMART" ALTER (IF APPROPRIATE).  IN     *
  *                      THIS CASE ALL NEWLY ADDED COLUMNS IN    *
  *                      SOURCE DDL ARE AT THE END OF THE TABLE. *
  *                      IF THE EXTRA COLUMN FROM THE TARGET DDL *
  *                      IS REMOVED, "SMART" ALTER IS GENERATED  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DURING COMPARE PROCESSING "SMART" ALTER WAS NOT SELECTED WHEN
  OPTION "SUPPRESS DROP OF COLUMNS" WAS IN EFFECT, ALONG WITH AN
  EXTRA COLUMN IN THE TARGET DDL.  WHEN THE EXTRA COLUMN IN THE
  TARGET DDL IS REMOVED, "SMART" ALTER IS SELECTED.
  

Problem conclusion

• THE PROBLEM IS FIXED IN DB2 OBJECT COMPARE V7.2 AND V7.1
  

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:

Modules/Macros

•    GOC2CMF
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK29839

     UP07/10/18 P F710

• R720 PSY UK29840

     UP07/10/18 P F710

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.