PH22460: ADMIN TOOL SQLCODE = -20180 ALTER TABLE ADD VERSIONING USE HISTORY TABLE EXECUTED BEFORE ALTER TABLE ALTER COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a base table of a history complex is altered (for
  example, to alter the default value of a column), Admin Tool
  generates the ADD VERSIONING command before the ALTER TABLE
  ALTER COLUMN command in the run job.  When the commands are
  executed in this order, the result may be SQL error -20180:
  
  
  DSNT408I SQLCODE = -20180, ERROR:  COLUMN >columname< IN TABLE
  >tablename< CAN NOT BE ALTERED AS SPECIFIED
  
  
  Keyword:  SQLCODE20180N
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Object Comparison Tool          *
  *                 for z/OS who use temporal and history        *
  *                 tables.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare wrote ALTER TABLE        *
  *                      statements to the work statement list   *
  *                      (WSL) in the wrong order. When run,     *
  *                      these statements result in a            *
  *                      SQLCODE = -20180 error.                 *
  ****************************************************************
  Comparing temporal and history tables with a change to the
  default value for a column might cause ALTER TABLE statements
  to be written in an incorrect order in the WSL. When the WSL is
  run, the statements in the wrong order result in the following
  error:
  
  SQLCODE = -20180, ERROR: COLUMN >column_name< IN
  TABLE >table_name< CAN NOT BE ALTERED AS SPECIFIED
  

Problem conclusion

• The problem has been resolved.
  
  Search keywords: SQLCODE20180N
  

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:

  UI70258

Modules/Macros

• ADB2CME  ADB2CMP  ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI70258

     UP20/07/06 P F006

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.