PK80471: ALC ALTER INDEX BEFORE CREATE TABLE / CREATE INDEX RESULTS IN SQ LCODEN204 DSNT408I ERROR AAA.AAA IS AN UNDEFINED NAME

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS ALC command created out of
  sequence DDL such that an ALTER INDEX occurred before the CREATE
   TABLE / CREATE INDEX DDL resulting in:
  DSNT408I SQLCODE = -204, ERROR:  aaaaaa.aaaaaaaa IS AN UNDEFINED
  NAME
  DSNT418I SQLSTATE   = 42704 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXISB1 SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 130  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool who use     *
  *                 the ALC and its Alter-Related function.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: A table change using ALC was being made *
  *                      which  resulted in  the  change  action *
  *                      being "DROP-SC" Drop with kip Convert). *
  *                      Additionally,  a column was added to an *
  *                      index using  the Alter-related function *
  *                      of ALC.                                 *
  *                                                              *
  *                      When  the table is dropped,  the new    *
  *                      CREATE  INDEX  statement  should  be    *
  *                      used. This statement was being built    *
  *                      and was  included in the job, but an    *
  *                      ALTER  INDEX  incorrectly  was being    *
  *                      built as  well and came ahead of the    *
  *                      CREATE TABLE statement.                 *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  SQLCODE204 may occur when adding a column to an existing index
  while using ALC and the Alter-related function.
  

Problem conclusion

• The problem is fixed so that the CREATE INDEX statement is used.
  The ALTER INDEX statement will not be used.
  

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:

Modules/Macros

•    ADB27CR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK44862

     UP09/03/18 P F903

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.