PK13475: SQLCODE669 FROM ALC PRIMKEY CHANGE TO PRIMARY KEY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool receives sqlcode669 from ALC PRIMKEY
  change to primary key when DROP INDEX occurs prior to DROP
  of the primary key.
  .
  Additional symptoms: sqlcoden669 -669 669 adb27c adb27ca
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users  of DB2 Administration Tool, who use   *
  *                 ALC to  change a primary Key  or  change a   *
  *                 column to an identity column, are affected   *
  *                 affected. Note: on DB2 Version 8 only        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An SQL CODE -669 was  encountered  from *
  *                      ALC PRIMKEY change to Primary Key  when *
  *                      DROP INDEX occurs prior to DROP of  the *
  *                      Primary Key.                            *
  *                      .*                                      *
  *                      SQLCODE669 may occur when attempting to *
  *                      change the primary key.                 *
  *                      .*                                      *
  *                      SQLCODE190  may  occur  when attempting *
  *                      to  change  an  existing  column to  an *
  *                      identity column (GENERATED BY DEFAULT). *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• A DROP of the existing primary index was being attempted ahead
  of removing the table's primary key definition first.
  .*
  An existing column cannot be changed to an identity column
  merely by an ALTER statement.  The object must be dropped and
  recreated.
  .*
  The problems have been fixed.
  

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:

  UK09641

Modules/Macros

•    ADB26CTP ADB27C   ADB27DUP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK09641

     UP05/12/06 P F512

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.