PH16964: OBJECT COMPARISON TOOL COLUMN CHANGES TABLE UTS DROP/CREATE NOT ALTERS; VIEW "SELECT *" NOT CHANGED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An Object Compare job where a column are dropped from and
  added to a table in a UTS tablespace generates a DROP/CREATE
  of the table instead of ALTER statements.  Furthermore,
  a dependent view defined as "select *" is marked as not
  changed.
  
  This fix ensures that, when option Unload Altered Tables is set
  to 'Y', the resulting change to add/drop columns to/from the
  table will be done using ALTER statements.  The dependent
  view with "select *" will then be dropped and recreated to
  refresh the "select *" columns after the column changes have
  been completed.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: User of DB2 Administration Tool for Z/OS who *
  *                 use the Unload Altered Tables option.        *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the Unload Altered Tables option   *
  *                      is set to 'Y', a change involving       *
  *                      dropping and appending columns on a     *
  *                      table in a UTS tablespace generates a   *
  *                      DROP/CREATE of the table when the       *
  *                      change could have been accomplished     *
  *                      using ALTERs. Additionally, a dependent *
  *                      view defined as "select *" is marked    *
  *                      as not changed.                         *
  ****************************************************************
  This fix ensures that, when using option Unload Altered
  Tables = Y, the resulting change to drop/add columns from/to
  the table will be done using ALTER statements. After the
  completion of the column changes, the dependent view will then
  be dropped and recreated, thus refreshing the "select *"
  columns.
  

Problem conclusion

• The 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:

  UI67436

Modules/Macros

• ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI67436

     UP20/02/04 P F001

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.