PK27770: ALC CHANGES OF COLUMN INCLUDED IN CHECK CONSTRAINT FAILS WITH SQ LCODE148

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool ALC line command being used to
  change a column defined in a CHECK CONSTRAINT fails with
  a SQLCODE -148.
  Additional search arg:
  SQLCODEN148 SQLCODE148N
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool,  who       *
  *                 use ALC to change a column defined  in       *
  *                 a CHECK CONSTRAINT, may be affected.         *
  *                 .* Note:                                     *
  *                 This  problem  was the result of a DB2       *
  *                 problem that has been corrected.             *
  *                 Therefore, PK27770  fix essentially is       *
  *                 a NO-OP.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: ALC  line command being used to change  *
  *                      a column defined in a CHECK CONSTRAINT  *
  *                      fails with a SQLCODE -148.              *
  *                      .* Note:                                *
  *                      DB2  was exhibiting divergent behavior  *
  *                      between  V7  &  V8  when 'DISTINCT' is  *
  *                      part of a 'LEFT OUTER JOIN.'            *
  *                      .* Note:                                *
  *                      This  problem  was the result of a DB2  *
  *                      problem that has been corrected.        *
  *                      Therefore, PK27770  fix essentially is  *
  *                      a NO-OP.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• See Problem Description.
  

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

•    ADB21T
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK18367

     UP06/10/05 P F610

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.