A fix is available
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 number
PH46973
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-06-03
Closed date
2022-09-09
Last modified date
2022-10-03
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
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.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 October 2022