PK18124: SQLCODEN205 FOR CREATE INDEX WHEN COLUMNS TO BE ADDED VIA ALTER AND COMPARE AT DATABASE LEVEL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Comparision Tool for z/OS generated DDL out of
  sequence for an object which had columns added resulting in a
  SQLCODEN205 / -205 for the CREATE INDEX. The ALTER statements
  adding the columns appeared out of sequence in the WSL.
  

Local fix

• Move the ALTER statements in the WSL.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool, who     *
  *                 use  ALTER, and  Compare at the Database     *
  *                 level, may be affected.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The generated  DDL  was out of sequence *
  *                      for  an object  which had columns added *
  *                      and   it  consequently  resulted  in  a *
  *                      SQLCODE -205 for the CREATE INDEX.  The *
  *                      ALTER  statements  adding  the  columns *
  *                      appeared out of sequence in the WSL.    *
  *                      .*                                      *
  *                      DDL was generated  out of sequence when *
  *                      comparing at the  database level.  This *
  *                      resulted in an SQLCODE -205 from CREATE *
  *                      INDEX  as  the  ALTER statements appear *
  *                      after the CREATE INDEX statement.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  SQLCODE -205 occurred for CREATE INDEX when COLUMNS to be added
  via ALTER and COMPARE at DATABASE level.
  

Problem conclusion

• Apply the fix.
  

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:

  UK13805 UK13806

Modules/Macros

•    GOC2CMF
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R310 PSY UK13805

     UP06/04/29 P F604

• R710 PSY UK13806

     UP06/04/28 P F604

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.