PH31735: DB2 OBJECT COMPARE ERROR ADB8035E ATTEMPT UPDATE VERSION FILE MATCHING ROW IN A DELTA CHANGE NOT FOUND

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A Compare process that includes complex table
  changes may result in the following error:
  
  ADB8035E An attempt was made to update a version file row, but
  the matching row specified in a delta change was not found
  ADB8068I Partial statement at the point of error:
           ALTER TABLESPACE >database<.>tablespace< PARTITION 5
  COMPRESS YES
  ADB8057I Object details at the time of error:
               Operation       : 296
               Row type        : TP
               Object qualifier: >database<
               Object name     : >tablespace<
               Procedure       : merge_tablespaces
  
  
  Keywords:  MSGADB8035E; MSGADB8068I; MSGADB8057I
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Object Comparison Tool for      *
  *                 z/OS who perform complex table changes.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Compare processing involving multiple   *
  *                      changes to a table might result in      *
  *                      error ADB8035E during the analyze       *
  *                      process.                                *
  ****************************************************************
  Analyzing a complex table change, such as one adding columns and
  partitions, and reordering columns at the same time, may result
  in an error such as the following:
  
  ADB8035E An attempt was made to update a
  version file row, but the matching row
  specified in a delta change was not found.
  ADB8068I Partial statement at the point of error:
  ALTER TABLESPACE >database name<.>table space name<
  PARTITION 5 COMPRESS YES
  ADB8057I Object details at the time of error:
  Operation : 296
  Row type : TP
  Object qualifier: >database name<
  Object name : >table space name<
  Procedure : merge_tablespaces
  

Problem conclusion

• The problem has been resolved.
  
  Search keywords: MSGADB8035 MSGADB8035E
  

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:

  UI74388

Modules/Macros

• ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI74388

     UP21/03/16 P F103

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.