PK99473: PRIMARY KEY AND IT'S ENFORCING INDEX ARE DROPPED IN WRONG SEQUENCE IF OBJECT CREATED BEFORE DB2 9

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS Change Management function
  creates a CHG file with a DROP INDEX and a DROP PRIMARY KEY
  which is processed in the wrong order.
  
  This issue only occurs on objects defined before DB2 9 i.e.
  on objects defined on a subsystem at a prior release of DB2
  which has then been migrated to DB2 9.
  A blank owner field in the version file will inherit the value
  from the creator field.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison               *
  *                 Tool for z/OS who compare DB2                *
  *                 v8 objects to DB2 v9 objects.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Primary key and primary key             *
  *                      index were dropped in the               *
  *                      wrong order.  Mismatched                *
  *                      OWNER fields were causing               *
  *                      unnecessary drop/create.                *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The ALTER DROP PRIMARY KEY statement was
  not recognized as such so the prefix field was set
  incorrectly. The OWNER fields from DB2 v8 objects
  default to blank.  OWNER fields from DB2 v9 are
  not blank.  This caused a drop/create that was
  not necessary.
  

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:

Modules/Macros

•    GOC2CMF  GOC2CMT
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK55339

     UP10/03/24 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.