PK67717: ALC PRIMKEY ALTER ADD COLUMN RESULTS IN SQLCODE -625/SQLCODEN625

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool ALC commands PRIMKEY does not
  create the correct sequence of statements to add a column to
  an existing primary key resulting in the ALTER statement failing
  SQLCODE -625 TABLE aaa.aaa DOES NOT HAVE AN INDEX TO ENFORCE THE
  UNIQUENESS OF THE PRIMARY OR UNIQUE KEY
  Additional search args:
  SQLCODEN625
  

Local fix

• If PROMPT enabled use option 3A on panel ADB2PSTM
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2  Administration Tool V72 using  *
  *                 the ALC line command to add a column to the  *
  *                 primary key.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: When  adding a column to the primary    *
  *                      key and changing  an existing  index    *
  *                      to  support the new primary key, the    *
  *                      product may  build the statements in    *
  *                      an improper sequence, which may lead    *
  *                      to SQLCODEN625.                         *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  When adding a column to an existing primary key, SQLCODEN625 may
  occur if an  index does not exist that  supports the new primary
  key signature.
  

Problem conclusion

• The problem has 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:

Modules/Macros

•    ADB27CA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK41295

     UP08/11/21 P F811

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.