PK64033: ADBCCME ERROR, WHEN CM ENABLED AND COLUMN REPEATED AND ORIGINAL COLUMN DELETED WITHOUT ANY CHANGES IN COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool, when using Change Management and
  a column is repeated, then the original column is deleted
  without making changes in the repeated column, Analyze of the
  change results in ADBCCME error.
  REPORT  : ADBCCME - Error(s) found. Please review output
  SYSPRINT: Column xxxxx to be inserted already exists in
            table tbowner.tbname
            ADBC002E - Severe error. Merge terminates,
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool who         *
  *                 use ALC and the Change Management            *
  *                 function.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool, when using  *
  *                      Change Management in ALC and a column   *
  *                      is repeated, and then the original      *
  *                      column is deleted without changing the  *
  *                      name of the repeated column, Analyze of *
  *                      the change results in an error in       *
  *                      ADBCCME.                                *
  *                      REPORT  : ADBCCME - Error(s) found.     *
  *                       Please review output                   *
  *                      SYSPRINT: Column xxxxx to be inserted   *
  *                       already exists in table tbowner.tbname *
  *                      ADBC002E - Severe error. Merge          *
  *                       terminates                             *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The repeated column operation was performed prior to
  the dropped column operation.  ADBCCME detected that
  the repeated column name already existed in the table,
  having not yet processed the dropped column operation.
  

Problem conclusion

• The order in which the statements are presented to
  ADBCCME has been changed, placing the drop column
  operations ahead of any inserted or repeated columns.
  

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

•    ADB2CCA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK36514

     UP08/05/30 P F805

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.