PH42627: OBJECT COMPARE INCORRECTLY GENERATES DROP/CREATE INSTEAD OF ALTER WHEN CHANGING SET DEFAULT VALUE NON-LOB COLUMN ADB7145I

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When tables with LOB columns are compared and the resulting
  change is supposed to be to the SET DEFAULT value of a non-lob
  column, Object Compare performs a DROP/CREATE instead of a
  simple ALTER COLUMN SET DEFAULT.
  
  Object Compare generates message ADB7145I: Column >column_name<
  cannot be altered by the ALTER TABLE ALTER COLUMN SET WITH
  DEFAULT statement, Reason 2.  This message should be issued only
  in the case of a LOB column SET DEFAULT change, specifically
  when the new default length is greater than the inline length.
  
  This is not applicable in the current case as the column is not
  a LOB column.
  
  Keyword:  msgadb7145I
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who compare column changes                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the default value of a non-LOB     *
  *                      column is changed, Db2 Admin Tool       *
  *                      incorrectly generates DROP and CREATE   *
  *                      statements instead of an ALTER          *
  *                      statement.                              *
  ****************************************************************
  When comparing tables with differences in the default value of
  non-LOB columns, Db2 Admin Tool incorrectly assumes that the
  columns are LOB columns and generates a DROP and CREATE of the
  table instead of issuing an ALTER statement to change the
  default value and incorrectly presents the user with an ADB7145I
  message in the report.
  

Problem conclusion

• The problem has been resolved.
  
  Search Keywords: LOBColumns ADB7141I
  

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:

  UI79564

Modules/Macros

• ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI79564

     UP22/04/01 P F203

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.