PH24400: DB2 ADMIN TOOL - ADB3006E ERROR OCCURS WHEN ADDING A NEW COLUMN TO A TABLE AND ALTERING THE INDEX TO INCLUDE IT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Admin tool:  When altering a table to add a new
  column, and then altering an index to include the new column,
  the new column isn't found
  
  Example:
  
  ALTER TABLE A.TAB1
    ADD
      COL1   DECIMAL(9, 0) NOT NULL WITH DEFAULT;
  
  
  ALTER INDEX A.IND1
   ADD COLUMN (COL1 ASC);
  
  ADB3006E An error occurred while processing the
  Index A.IND1 object in the statement type of ALTER.
  The column COL1 doesn't exist in the table.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS or Db2 Object Comparison Tool for z/OS. *
  ****************************************************************
  * PROBLEM DESCRIPTION: When running JCL in a WSL,              *
  *                      a failure occurs with message ADB3006E  *
  *                      when using CM batch parm                *
  *                      Validate_WSL = 'Y'                      *
  *                                                              *
  *                      when trying to validate an ALTER INDEX  *
  *                      statement for an index and table that   *
  *                      were created before Db2 version 9.      *
  ****************************************************************
  When a user tries to run a CM batch job with parameter
  VALIDATE_WSL = 'Y',  the following error message is issued:
  ADB3006E An error occurred while processing the Index
  'index name' object in the statement type of ALTER.
  The COLUMN 'column name' doesn't exist in the table.
  
  The column does exist in the table.  However, because the
  index and table were created before Db2 version 9, the
  SYSINDEXES catalog table has trailing blanks in the
  TBCREATOR column.
  

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:

  UI70850

Modules/Macros

• ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI70850

     UP20/08/04 P F008

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.