PK96038: CHANGE MANAGEMENT CHG FILE CONTAINS AN EXTRA ALTER TABLE ADD CONSTRAINT PRIMARY KEY MERGE "ADD PRIMARY KEY FAILED" ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS Change Management function
  created a CHG file with an additional:
    ALTER TABLE... ADD CONSTRAINT ... PRIMARY KEY (....)
  when a MASK is used and the targeted object was created
  before DB2 9.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison               *
  *                 Tool for z/OS who compare tables             *
  *                 with unique constraints                      *
  *                 created with DB2 before V9.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare generates                *
  *                      ALTER TABLE ADD PRIMARY                 *
  *                      KEY statement although a                *
  *                      CREATE TABLE statement                  *
  *                      with primary key has been               *
  *                      already generated for the               *
  *                      same table. This causes                 *
  *                      Analyze.merge to fail with              *
  *                      message:                                *
  *                      Add primary key failed.                 *
  *                      Table 'table_name'                      *
  *                      already has a                           *
  *                      primary key.                            *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  DB2 Object Comparison Tool generates ALTER
  TABLE ADD PRIMARY KEY statement although
  a CREATE TABLE statement with primary key has
  been generated for the same table.
  

Problem conclusion

• DB2 Object Comparison Tool is changed to
  correctly detect unique constraints.
  

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

•    GOC2CMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK54758

     UP10/03/04 P F003

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.