A fix is available
APAR status
Closed as program error.
Error description
Object Compare: DB2_GENERATED_DOCID_FOR_XML implicit column not being ignored DESCRIPTION: When comparing tablespaces from 2 catalogs with identical columns except for the position of DB2_GENERATED_DOCID_FOR_XML column, Object Compare recreates the table instead of ignoring the implicit column.
Local fix
na
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * who want to compare tables with * * DB2_GENERATED_DOCID_FOR_XML columns * **************************************************************** * PROBLEM DESCRIPTION: Comparing tables that differ only in * * the column position of an implicit * * DB2_GENERATED_DOCID_FOR_XML column * * resulted in reordering the * * columns. * **************************************************************** * RECOMMENDATION: ............................................ * **************************************************************** Currently, Db2 Admin Tool includes a DB2_GENERATED_DOCID_FOR_XML column when comparing tables. Including this column in the comparison causes Db2 Admin Tool to try to reorder the columns by dropping and recreating the table, even when the only change is the location of the DB2_GENERATED_DOCID_FOR_XML column. With this APAR applied, Db2 Admin Tool does not include the implicitly generated column in the comparison, so dropping and recreating the table is not necessary.
Problem conclusion
The problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH47295
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-17
Closed date
2022-11-16
Last modified date
2022-12-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI82698 UI82699
Modules/Macros
ADB2CMT
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:
01 December 2022