PI93801: DB2 ADMIN TOOL - MERGE ERROR WHEN DROPPING COLUMN FROM TEMPORAL TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Merge error when importing the following script:
  
  ALTER TABLE ADMINT.TBL90A DROP VERSIONING;
  ALTER TABLE ADMINT.TBL90A DROP COLUMN VIDI RESTRICT;
  ALTER TABLE ADMINT.TBL90B DROP COLUMN VIDI RESTRICT;
  ALTER TABLE ADMINT.TBL90A ADD VERSIONING
  USE HISTORY TABLE ADMINT.TBL90B;
  
  ADB8028E An attempt was made to drop a column, but that column
           does not exist in the table.
  ADB8057I Object details at the time of error:
  Operation : 50
  Row type : TB
  Object qualifier: ADMINT
  Object name : TBL90A
  Procedure : merge_tables
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use the Change Management           *
  *                 function.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Dropping a column from temporal table   *
  *                      followed by dropping the column from    *
  *                      history table results in error ADB8028E *
  *                      during analyze.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Dropping the column from temporal table followed by dropping
  the column from history table results in error during analyze:
  
  ALTER TABLE >temporal table< DROP VERSIONING;
  ALTER TABLE >temporal table< DROP COLUMN >column name< RESTRICT;
  ALTER TABLE >history table< DROP COLUMN >column name< RESTRICT;
  ALTER TABLE >temporal table< ADD VERSIONING USE HISTORY TABLE
  >history table<;
  
  ADB8028E An attempt was made to drop a column, but that column
  does not exist in the table.
  
  ADB8057I Object details at the time of error:
  Operation : 50
  Row type : TB
  Object qualifier: >qual<
  Object name : >temporal table<
  Procedure : merge_tables
  

Problem conclusion

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

  UI55971 UI55972

Modules/Macros

•    ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI55971

     UP18/05/23 P F805

• RC10 PSY UI55972

     UP18/05/23 P F805

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.