PI81346: DB2 ADMIN TOOL - RENAME OF A COLUMN IN TEMPORAL AND HISTORY TABLES RESULTED IN ANALYZE ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A logical sequence of the DDL's to rename a column of a table
  with its history table looks as follows:
   1. drop versioning
   2. alter base table (rename column)
   3. alter (former) history table (rename column)
   4. alter base table add versioning again.
  
  This sequence of DDL statements can be executed successfully in
  AOC (execute SQL statements), but fails with RC=12 when trying
  to import it in CMBATCH for execution.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool or          *
  *                 DB2 Object Comparison Tool for z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a user analyzes a change which     *
  *                      renames a column of a table with its    *
  *                      history table in the following          *
  *                      logical sequence:                       *
  *                                                              *
  *                      1. drop versioning                      *
  *                      2. alter base table (rename column)     *
  *                      3. alter (former) history table         *
  *                      (rename column)                         *
  *                      4. alter base table add versioning      *
  *                      again .                                 *
  *                                                              *
  *                      the series of operations ends with      *
  *                      error ADB8052E / msgadb8052e:           *
  *                                                              *
  *                      ADB8052E A change was found for         *
  *                      table_name but no base definition was   *
  *                      found.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When analyzing a change which renames a column of a table in
  its history table, DB2 Admin fails with error ADB8052E /
  msgadb8052e and return code 12 / RC12 when trying to import
  it in CMBATCH.
  

Problem conclusion

• The problem has been resolved.
  The solution is to support the above valid sequence of
  statements. If renaming a column of a history table, and
  an error is encountered, the new error message ADB8060E /
  msgadb8060e will be issued:
  
  ADB8060E The renaming a column in history table tb_name
  is invalid.
  Explanation:
  The ALTER TABLE RENAME COLUMN cannot be issued against the
  tb_type table which is invalid.
  System Action:
  Processing stops
  

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

•    ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI48497

     UP17/07/07 P F707

• RB20 PSY UI48498

     UP17/07/07 P F707

• RC10 PSY UI48499

     UP17/07/07 P F707

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.