PK52043: CM MESSAGE 'ALTER INCONSISTENCY IN ROWTYPE, LGTH OR PREFIX' WHEN CHANGES FILE CONTAINS A LABEL STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool Change Management feature reports a
  Merge Report error:
  ADBCCME - Error(s) found. Please review output
  alter inconsistency in rowtype, lgth or prefix
  ADBC002E - Severe error. Merge terminates
  when the imported changes file contains a LABEL statement:
  CREATE    LABEL   ON TABLE aaa.aaa IS 'bbbbb' ;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: In R720,when user  imports delta change      *
  *                 dataset and try to analyze the register      *
  *                 change.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: After importing a delta change dataset, *
  *                      analyzing the registered change results *
  *                      in  RC12 with error in merge.           *
  *                        'alter inconsistency in rowtype, gth  *
  *                         or prefix ADBC002E - Severe  error.  *
  *                         Merge terminates'.                   *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Since TABLE is not part of input in change statement LABEL,table
  type ends with unknown, with which prefix group and subgroup are
  not reset to default table label type.
  

Problem conclusion

• The problem is been fixed only in V7.2.
  

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

•    ADBCDTS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK30223

     UP07/10/25 P F710

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.