PH61897: INDICATION OF THE REASON FOR CONVERSION BY DROP/CREATE FOR INSERTED COLUMNS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Indication of the reason for conversion by drop/create for
  inserted columns.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR adds an enhancement to        *
  *                      provide a more informative message      *
  *                      when a table is dropped and             *
  *                      recreated for inserted columns.         *
  ****************************************************************
  Object Compare now generates the following message
  when a table is dropped and recreated because a
  column was inserted before an existing column:
  
  ADB7234I ALTER TABLE ADD COLUMN cannot be
  generated for table table_schema.table_name. New
  column column_name was inserted before an existing
  column.
  

Problem conclusion

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:

  UI97396

Modules/Macros

• ADB2CMT  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI97396

     UP24/06/22 P F406  

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.