PI98930: ADMIN TOOL CM COMPARE ALTER MAY FAIL ADBC139E INTFIN AND C001 MISMATCH. COLNAMES NOT EQUAL RC=12

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When executing an  ALTER TABLE via CM Batch or Compare
  involving  an UNLOAD using TEMPLATEs, some of the columns in the
  subsequent LOAD statement contain generated values with special
  considerations and column names prefixed with the "DSN_"
  keyword. This may lead to the following error, and the
  termination of the job with RC 12:
  ADBC139E INTFIN and C001 mismatch. Colnames not Equal
  INTFIN: OP_CODE C001 :
  DSN_OP_CODE
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and Db2 Object Comparison Tool          *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Generated expression columns are not    *
  *                      tolerated by ADB27AC, resulting in      *
  *                      error ADBC139E during ADBTEP2 run.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a table is altered, resulting in UNLOAD and LOAD of
  the data using TEMPLATEs, columns containing generated
  values are converted by DB2 in the LOAD statement to
  dummy field names, with the "DSN_" keyword prefixed
  to the column name. Such LOAD statement execution
  by the ADBTEP2 program may result in the error below:
  
  ADBC139E INTFIN and C001 mismatch. Colnames not Equal
  INTFIN: OP_CODE C001 : DSN_OP_CODE
  

Problem conclusion

• Problem has been 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:

  UI58310 UI58311

Modules/Macros

•    ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI58310

     UP18/09/20 P F809

• RC10 PSY UI58311

     UP18/09/20 P F809

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.