PM96590: JOB FAIL "ADBC139E INTFIN AND C001 MISMATCH" WHEN REN TABLE LOB

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 ADMINISTRATION TOOL FOR Z/OS.
  Rename table with lob column and hidden column ROWID, recover
  job fail with "ADBC139E INTFIN and C001 mismatch".
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and DB2 Object Comparison Tool for      *
  *                 z/OS who use the 'Alter Table ALT' (ALT)     *
  *                 function with Change Management.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Change Management RECOVER job       *
  *                      fails with error message ADBC139E /     *
  *                      msgadbc139e:                            *
  *                                                              *
  *                      "ADBC139E INTFIN and C001 mismatch"     *
  *                                                              *
  *                      when as part of the original change,    *
  *                      the user inserts a column before the    *
  *                      hidden ROWID column which is also       *
  *                      the last column in the table.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Program does not retrieve the correct table structure for a
  RECOVER change and the original table structure contains a
  change like inserting a column before the ROWID column which
  is also the last column in the table.
  

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:

Modules/Macros

•    ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI24415

     UP15/01/18 P F501

• RB10 PSY UI24416

     UP15/01/18 P F501

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.