PI67552: SQLCODE -20180 WHEN COLUMN BEING ALTERED IS IN EXTENDED INDEX

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When altering a column which participates in an extended index,
  Change Management or Object Compare does not drop the index (to
  be recreated later) before executing the alter statement,
  resulting in a SQLCODE=-20180 error:
  DSNT408I SQLCODE = -20180,  ERROR:  COLUMN >colname<
   IN TABLE >tablename< CAN NOT BE ALTERED AS SPECIFIED.
  

Local fix

• N/A.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and DB2 Object Comparison           *
  *                 Tool for z/OS who make a change to           *
  *                 a table column, which is referenced in       *
  *                 an index 'ON' expression.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using 'ALT - Alter Table' to       *
  *                      generate a statement to alter a         *
  *                      table column, if that column            *
  *                      is referenced in an index 'ON'          *
  *                      expression, the index is not dropped    *
  *                      first.  Executing the APPLY             *
  *                      jobs / Work Statement List (WSL)        *
  *                      will fail with a SQLCODEN20180 /        *
  *                      SQLCODE=-20180.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using 'ALT - Alter Table' to generate a statement to alter
  a table column, if that column is referenced in an index 'ON'
  expression, the index is not dropped first.  Executing the APPLY
  jobs / Work Statement List (WSL) will fail with a SQLCODEN20180
  SQLCODE=-20180.
  
  DSNT408I SQLCODE = -20180, ERROR:  COLUMN >colname<
  IN TABLE >tablename< CAN NOT BE ALTERED AS SPECIFIED.
  

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:

  UI42005 UI42006

Modules/Macros

• ADB2CME  ADB2CMF
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI42005

     UP16/11/01 P F610

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.