PM07202: ALC FAILS RC1012 AND ADBC139E INTFIN AND C001 MISMATCH. COLNAMES NOT EQUALINTFIN: UNIQUE_ID C001 : UNIQUE_ID_IDENTITY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS ALC command fails RC1012
  with a message:
  
  ADBC139E INTFIN and C001     mismatch. Colnames not Equal
           INTFIN: column_name                   C001    :
  column_name
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who alter a table with a ROW CHANGE     *
  *                 TIMESTAMP column and use High Performance    *
  *                 Unload/HPU Unload.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: If a ROW CHANGE TIMESTAMP column is     *
  *                      unloaded with HPU, the column name is   *
  *                      appended with "_ROW_CHANGE_TIMESTAMP"   *
  *                      in the SYSPUNCH control cards           *
  *                      generated by HPU, which results in the  *
  *                      message ADBC139E "INTFIN and C001       *
  *                      mismatch.  Colnames not equal."         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The code did not recognize renaming of a ROW CHANGE
  TIMESTAMP column when using HPU.
  

Problem conclusion

• The problem is resolved.
  

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 UK64492

     UP11/02/06 P F102

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.