PM31990: ALTER IN CONSTRAINT LENGTH DROPS AND RECREATES TABLE INSTEAD OF DROP CONSTRAINT/ALTER TABLE/ADD CONSTRAINT/CHECK/REORG UTIL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When DB2 Object Comparison Tool for z/OS detects a difference
  in the constraint length, tool drops/recreates table instead
  of DROP CONSTRAINT, ALTER TABLE, ADD CONSTRAINT, run UTILITIES
  CHECK and REORG.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who compare tables with check           *
  *                 constraints.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a change is made to a column       *
  *                      which has a CHECK CONSTRAINT defined    *
  *                      against it, DB2 Object Compare          *
  *                      performs a DROP/CREATE of the table     *
  *                      and does not allow ALTER.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a change is made to a column which has a CHECK CONSTRAINT
  defined against it, DB2 Object Compare performs a DROP/CREATE
  of the table and does not allow ALTER.
  

Problem conclusion

• DB2 Object Compare is fixed to use DROP CONSTRAINT, ALTER
  TABLE, ADD CONSTRAINT, and follow up with the CHECK DATA and
  REORG utilities.
  

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

•    ADB2CMR  ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK66440

     UP11/04/08 P F104

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.