PI22658: MSG NO CHANGES IS ISSUED WHEN ALTERING PRIMARY KEY CONSTRAINT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS issues message "No changes"
  when attempting to alter only the primary key constraint.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS 'ALT Alter Table' (ALT) function who    *
  *                 want to modify a primary key constraint      *
  *                 name.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: ADB200W / msgadb200w short message      *
  *                      'No changes', and upon pressing the     *
  *                      F1 key, long message 'No further        *
  *                      action necessary since no changes       *
  *                      were made' is displayed after           *
  *                      changing the primary key constraint     *
  *                      name within the ALT process.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Changing the primary key constraint name without also changing
  the constraint key is not currently supported.
  

Problem conclusion

• New error message ADB588E / msgadb588e is now issued if an
  attempt is made to change the primary key constraint name
  without changing the constraint key.  In addition, new message
  ADB589E / msgadb589e is now issued when adding a new primary
  or unique key constraint without specifying any columns for
  its key.
  
  The following new messages are added:
  
  ADB588E You must change one or more keys in order to change
  the primary key constraint name.
  
  Explanation
  You cannot change the primary key constraint name without also
  changing one or more keys for the constraint.
  System action
  Processing stops.
  User response
  Change one or more of the constraint columns, or restore the
  original constraint name.
  
  ADB589E You must choose one or more columns for the
  constraint key.
  
  Explanation
  You must specify one or more columns for the constraint key
  when adding a primary or unique key constraint.
  System action
  Processing stops.
  User response
  Specify one or more columns for the key before proceeding.
  

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:

  UI21543

Modules/Macros

•    ADBE7CTP ADBP7CN  ADBP7CTP ADB58
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI21543

     UP14/09/24 P F409

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.