PK52113: CM ANALYZE JOB FAILS RC 12 'INSERT COL UNABLE TO LOCATE POSITION COLUMN' WHEN TWO COLUMNS ADDED TO TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool Change Management ANALYZE job
  fails RC=12 with a message issued by MERGE REPORT:
  ADBCCME - Error(s) found. Please review output
  INSERT col unable to locate POSITION column
  ADBC002E - Severe error. Merge terminates
  when columns added to table.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Object Compare/Admin 720 with       *
  *                 Change Management.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: When comparing two tables where the     *
  *                      source table have at least two columns  *
  *                      added at the end, the generated change  *
  *                      will have a wrong statement ADMIN ALTER *
  *                      TABLE INSERT COLUMN aaaa .... BEFORE    *
  *                      bbbb. bbbb will not be a valid column   *
  *                      name.                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  OC has been modified to generate ALTER TABLE ADD COLUMN ....
  statements for all appended columns.
  

Problem conclusion

• The problem has been fixed.
  

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:

  UK30239

Modules/Macros

•    GOC2CMF
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK30239

     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.