IC72806: DROPPING A PRIMARY KEY COLUMN AND RECREATING PRIMARY KEY IN SAME ALTER STATEMENT CAUSES SERVER ABEND

APAR status

• Closed as fixed if next.

Error description

• If you drop a column that also is part of a multi-column primary
  key and recreate the primary key constraint in the same ALTER
  TABLE statement, this can cause a server abend.
  

Local fix

• Separate the alters into multiple alter table statements.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This problem is not platform specific.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Same Alter statement which drops primary key column and      *
  * recreates the primary key abends server.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC9.                                        *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

• http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp
  For download information, go to:
  http://www.ibm.com/support/fixcentral
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• RB15 PSN

     UP