PH43274: ERROR SQLCODE -20181 WHEN ADDING COLUMN TO INDEX CONTAINING INCLUDE CLAUSE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Adding a column via an ALTER to an index that has at least 1
  INCLUDE column will result in a -20181 SQL error. To allow the
  addition of the column, the behavior in this specific scenario
  will be changed to a drop/recreate of the index.
  
  Keyword:  SQLCODE20181N
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Adding a column to an index results in  *
  *                      a -20181 SQL error.                     *
  ****************************************************************
  Compare generates a work statement list (WSL) that adds a column
  to an index with an
  ALTER operation. However, Db2 restricts adding a column
  to an index when that index has at least 1 INCLUDE column. The
  index must be dropped and recreated. Running the WSL results
  in the following error:
  
  SQLCODE = -20181, ERROR: COLUMN CANNOT BE ADDED TO INDEX
  >tb_schema<.>tb_name<
  
  Keyword: SQLCODE20181N
  
  A list of Db2 restrictions for adding a column to an index can
  be found at
  https://www.ibm.com/docs/en/db2-for-zos/12?topic=codes-20181
  

Problem conclusion

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

  UI79887

Modules/Macros

• ADB2CME
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI79887

     UP22/04/01 P F203

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.