PK70153: ALTER GENERATES MSG ADBC197E CHECK CONDITION NOT VALID AFTER DATATYPE CHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Specifying ALC to alter 2 columns from character to integer with
  a check constraint on the table, but not on the columns being
  changed, generates error:
      CNVRT50  PROC:  COND_CODE:1012
      ADBC197E CHECK condition not valid after datatype change
  .
  Additional symptoms: msgADBC197E
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Admin Tool attempting to        *
  *                 alter a table with a check constraint        *
  *                 that references  columns of different        *
  *                 types.                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Message ADBC197E  CHECK condition  not  *
  *                      valid after datatype change  is issued  *
  *                      and ADB27AC terminates with the return  *
  *                      code 8 if a check constraint condition  *
  *                      references more than one column type.   *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The logic in  check_condition in ADB27AC  attempts to insure
  column type  consistency  within each condition  of a  check
  constraint,   however it does not  take ANDs or ORs into the
  consideration.   So the current  logic correctly  evaluates,
  say, "col1 > col2 + col3" (making sure col1, col2,  and col3
  are all of the same type),  but mistakenly expects these the
  columns must all be of the same type for the condition "col1
  > col2 AND col3 IS NOT NULL".
  

Problem conclusion

• ADB27AC check_condition logic is enhanced to take into account
  ANDs and ORs in check constraint definitions.
  

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

•    ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK40536

     UP08/10/15 P F810

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.