PK95436: ADBC139E INTFIN AND C001 MISMATCH. COLNAMES NOT EQUAL INTFIN: AAAAAAAA C001 : DSN_IDENTITY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS Change Management RN/Run
  function fails with a message:
  
  ADBC139E INTFIN and C001     mismatch. Colnames not Equal
           INTFIN: aaaaaaaa                        C001    :
  DSN_IDENTITY
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 who alter tables with IDENTITY columns.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: ALC terminates with RC=1012 with the    *
  *                      following message: "ADBC139E INTFIN and *
  *                      C001  mismatch. Colnames not Equal"     *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  DB2 UNLOAD produces a "dummy" column name of DSN_IDENTITY for
  IDENTITY columns in its SYSPUNCH output, replacing the actual
  name of the IDENTITY column. ADB27AC does not recognize that
  the discrepancy between the DDL column name and the SYSPUNCH
  column name can be safely ignored if the old column is an
  IDENTITY column.
  

Problem conclusion

• ADB27AC is modified to ignore the DDL/SYSPUNCH column name
  discrepancy if the old column is an IDENTITY column.
  

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

•    ADBCCMM  ADB27A   ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK53736

     UP10/01/28 P F001

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.