PH16068: CM BATCH SQLCODE = -204 / SQLCODEN204 CREATE INDEX COLUMN DROPPED FROM TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Currently, the parm validate_wsl cannot be used in CM Batch
  together with action_generate_wsl = 'Y'.  As a result, when
  a column that belongs to a secondary index is dropped from a
  table, CM Batch may still try to create the secondary index
  as it was before.  This may result in a SQLCODE -204 /
  SQLCODEN204 error at run time.
  
  With this fix applied, users will be able to set validate_wsl =
  'Y' together with action_generate_wsl = 'Y', so that
  an error like this can be flagged.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 who use the action_generate_wsl=Y CM Batch   *
  *                 parameter.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Validate_WSL cannot be used with        *
  *                      action_generate_wsl='Y' in CM batch,    *
  *                      and so will not flag an attempted       *
  *                      recreate of an index with a dropped     *
  *                      column.                                 *
  ****************************************************************
  Validate_wsl does not work when running with
  action_generate_wsl=Y instead of action_analyze_change. The
  result could be that CREATE INDEX DDL is generated with a column
  that no longer exists. When this command is executed, a
  SQLCODE -204 / SQLCODEN204 error may result.
  
  With this fix applied, Validate_wsl=Y can be used with
  action_generate_wsl=Y.
  

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:

  UI66295

Modules/Macros

• ADBCCM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI66295

     UP19/11/30 P F911

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.