PH47028: SQLCODE -625 WHEN ADDING A COLUMN TO AN INDEX AND PRIMARY KEY ONA TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The tablespace is out of scope when going through Change
  Management. Change Management was previously relying on the
  tablespace being in scope to order the statements. Statements
  were written to the change file with an ALTER prefix causing the
   ALTER INDEX ADD COLUMN statement to be after the ALTER TABLE
  ADD PRIMARY KEY statement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Adding a column to an index and the     *
  *                      primary key for the table might result  *
  *                      in SQLCODE -625.                        *
  ****************************************************************
  Analyzing a change to add a column to both an index and the
  primary key of a table in a segmented table space results in a
  work statement list (WSL) that when executed produces the
  following error:
  
  DSNT408I SQLCODE = -625, ERROR: TABLE >schema<.>name< DOES NOT
  HAVE AN INDEX TO ENFORCE THE UNIQUENESS OF THE PRIMARY OR
  UNIQUE KEY
  
  Keyword: SQLCODE625
  

Problem conclusion

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

  UI81939 UI81940

Modules/Macros

• ADB2CM3
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI81939

     UP22/09/01 P F208

• RD10 PSY UI81940

     UP22/09/01 P F208

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.