PH63723: INDICATION OF THE REASON FOR CONVERSION BY DROP/CREATE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Indication of the reason for conversion by drop/create
  

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 more informative messages       *
  *                      when a table is dropped and recreated   *
  *                      for the following cases:                *
  *                                                              *
  *                      1) When none of the columns on the      *
  *                      source and target match.                *
  *                                                              *
  *                      2) When columns on the source and       *
  *                      target are the same but in a different  *
  *                      order.                                  *
  *                                                              *
  *                      3) When some columns are shuffled or    *
  *                      reordered.                              *
  *                      Some on the target are deleted.         *
  *                      Some on the source are added.           *
  *                                                              *
  *                      4) When the source column length is     *
  *                      less than the target column length.     *
  *                                                              *
  *                      5) When the column type changes and     *
  *                      requires data conversion.               *
  *                                                              *
  *                      6) When the column subtype changes.     *
  *                                                              *
  *                      7) When the column type changes and     *
  *                      a clone table exists.                   *
  *                                                              *
  *                      8) When a generated expression column   *
  *                      type changes.                           *
  ****************************************************************
  Object Compare now generates the following messages
  when a table is dropped and recreated for following cases:
  
  1) When none of the columns on the source
    and target matches.
  
  ADB7243I ALTER TABLE ADD COLUMN cannot be generated for table
  table_name. None of the columns on the source and target match.
   Hence, the table will be dropped and recreated.
  
  2) When columns on the source and target
     are the same but in a different order.
  
  ADB7236I Columns on the source and target are the same for the
  table table_name but are not in the same order. To create the
  columns in source order, the table will be dropped and
  recreated.
  
  3) When some columns are shuffled or reordered.
     Some on the target are deleted.
     Some on the source are added.
  
  ADB7237I Resulting column changes for table table_name cannot
  be achieved through ALTERs.
  Hence, the table needs to be dropped and recreated.
  Some of the columns are reordered, and some of the columns
  are added.
  
  ADB7237I Resulting column changes for table table_name cannot
  be achieved through ALTERs.
  Hence, the table needs to be dropped and recreated.
  Some of the columns are reordered, and some of the columns are
  deleted.
  
  ADB7237I Resulting column changes for table table_name cannot
  be achieved through ALTERs.
  Hence, the table needs to be dropped and recreated.
  Some of the columns are reordered and added, and some of the
  columns are deleted.
  
  4) When the source column length is less
     than the target column  length.
  
  ADB7238I Because the source column length is less than the
  target column  length, the table must be dropped and
  recreated.
  
  5) When the column type changes and requires
     data conversion.
  
  ADB7239I Because this column data type change requires data
  conversion, the  table must be dropped and recreated.
  
  6) When the column subtype changes.
  
  ADB7240I Because this column subtype is changed, the table
  must be dropped  and recreated.
  
  7) When the column type changes and a clone table exists.
  
  ADB7241I Because this base table has clone table
  clone_creator.clone.tablename , this column type change
  requires the table to be dropped and recreated.
  
  8) When a generated expression column type changes.
  
  ADB7242I Because the column is a generated expression column,
  this column type change requires the table to be dropped and
  recreated.
  

Problem conclusion

• The enhancement has been delivered.
  

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:

  UI98816

Modules/Macros

• ADB2CMT  ADB2CMU  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI98816

     UP24/10/22 P F410  

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.