PK74058: DB2 OBJECT COMPARE ADD PRIMARY KEY FAILED. TABLE OWNER.NAME ALREADY HAS A PRIMARY KEY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 OBJECT COMPARE ADD PRIMARY KEY FAILED. TABLE OWNER.NAME
  ALREADY HAS A PRIMARY KEY
  

Local fix

• APPLY PTF.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool Ver 7.2  *
  *                 and DB2 Version 8 and higher.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR solves the following 2        *
  *                      problems.                               *
  *                                                              *
  *                      1) Enable non-zero error return codes   *
  *                         disabled by PK51390.                 *
  *                                                              *
  *                      2) Add return code 8 in case the number *
  *                         of the partitions for the tablespace *
  *                         was  reduced,   but  the  tablespace *
  *                         was not  part of the source and some *
  *                         partitions  don't have  the  default *
  *                         attributes.   The following  message *
  *                         will be issued:                      *
  *                                                              *
  *                           Number of the  partitions  for the *
  *                           tablespace should be reduced,  but *
  *                           the tablespace was not part of the *
  *                           source.                            *
  *                                                              *
  *                           Attempt to update the number of    *
  *                           partitions was not done because    *
  *                           some parts did not have default    *
  *                           attributes  so the result might    *
  *                           be wrong.                          *
  *                                                              *
  *                           Please  include the new  tablespac *
  *                           definition in the source and rerun *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  This APAR solves the following 2 problems.
  
  1) Enable non-zero error return codes disabled by PK51390.
  
  2) Add return  code 8 in case  the number of  partitions for the
     tablespace was reduced,   but the tablespace was  not part of
     the source and some partitions don't have default attributes.
     The following message will be issued:
  
       Number of partitions for the tablespace should be reduced,
       but the tablespace was not part of the source.
  
       Attempt  to update the  number of partitions was not done
       because some parts did not have default attributes so the
       result might be wrong.
  
       Please include the new tablespace definition in the source
       and rerun.
  

Problem conclusion

• The problem was 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

•    GOC2CMP  GOC2CMR
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK41565

     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.