PI70826: DB2 ADMIN TEMPORAL TABLES RENAME COLUMN RETURNS -601 ON HISTORY TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using DB2 Admin Tool to rename a column for a temporal table,
  the tool drops versioning and then tries to create the history
  table but never dropped it. The CREATE TABLE statment returns
  SQLCode -601 / SQLCODEN601
  DSNT408I SQLCODE = -601, ERROR:  THE NAME (VERSION OR VOLUME
           SERIAL NUMBER) OF THE OBJECT TO BE DEFINED OR THE
           TARGET OF A RENAME STATEMENT IS IDENTICAL TO THE
           EXISTING NAME (VERSION OR VOLUME SERIAL NUMBER)
           object-name OF THE OBJECT TYPE TABLE
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who alter a temporal table to           *
  *                 rename a column.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: When altering a temporal table to       *
  *                      rename a column, the apply job          *
  *                      fails with a SQLCODE=-601 /             *
  *                      SQLCODEN601.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When altering a temporal table to rename a column, the
  apply job recreates the history table but does not drop the
  history table, causing the following SQLCODE=-601 /
  SQLCODEN601 error:
  
  DSNT408I SQLCODE = -601, ERROR: THE NAME
  (VERSION OR VOLUME SERIAL NUMBER) OF
  THE OBJECT TO BE DEFINED OR THE TARGET
  OF A RENAME STATEMENT IS IDENTICAL TO THE
  EXISTING NAME
  

Problem conclusion

• The history table does not need to be dropped and recreated,
  as it uses the ALTER TABLE...RENAME COLUMN statement to
  rename the column name.
  

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

•    ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI46779

     UP17/04/29 P F704

• RC10 PSY UI46780

     UP17/04/29 P F704

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.