PH46973: OBJECT COMPARE REPORT - ERROR MESSAGE ADB8067E IN MERGE VERSION FILES SECTION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Object Compare shows message ADB8067E under the Merge Version
  Files section of the report when an implicit XML or LOB table
  space is a part of this comparison.
  
  ADB8067E Alter inconsistency in the row type, length, or prefix.
  
  ADB8068I Partial statement at the point of error:
  
  ADMIN ALTER IMPLICIT <XML or LOB> TABLESPACE FOR
  TABLE <table name>
  
  COLUMN(<column name>)
  
  ADB8057I Object details at the time of error:
  Operation : 295
  Row type : xx
  Object qualifier: <table qualifier>
  Object name : <table name>
  Procedure : alter_row
  
  Keywords: ADB8067E, ADMIN ALTER IMPLICIT XML TABLESPACE, ADMIN
  ALTER IMPLICIT LOB TABLESPACE
  

Local fix

• BYPASS/CIRCUMVENTION:
  NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who use Object Compare with an implicit XML  *
  *                 or LOB table space                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare reports message ADB8067E *
  *                      when an implicit XML or LOB table space *
  *                      is a part of the object comparison.     *
  ****************************************************************
  Message ADB8067E is erroneously included in the "Merge Version
  Files" section of the Object Compare report when an implicit XML
  or LOB table space is a part of the comparison.
  ADBCCMM - Merge Version Files
  ----------------------------------------------------------------
  ADB8067E Alter inconsistency in the row type, length, or prefix.
  
  ADB8068I Partial statement at the point of error:
           ADMIN ALTER IMPLICIT XML TABLESPACE FOR TABLE table-
           name COLUMN(column-name) USING STOGROUP stogroup-name
  ADB8057I Object details at the time of error:
               Operation       : 295
               Row type        : TP
               Object qualifier: table-qualifier
               Object name     : table-name
               Procedure       : alter_row
  
  Keywords: MSGADB8067E, ADMIN ALTER IMPLICIT XML TABLESPACE,
            ADMIN ALTER IMPLICIT LOB TABLESPACE
  

Problem conclusion

• The 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:

  UI82353 UI82377

Modules/Macros

• ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI82353

     UP22/10/03 P F209

• RD10 PSY UI82377

     UP22/10/03 P F209

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.