A fix is available
APAR status
Closed as program error.
Error description
When Merge is processing ADMIN ALTER INDEX <IXNAME> REPLACE COLUMNS, its possible for it to incorrectly delete the wrong column records leading to an invalid version file. This invalid version file then leads to severe issues later down in compare. Merge should properly delete the correct column records to maintain a valid version file.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * and Db2 Object Comparison Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: The merge function generates an invalid * * version file when processing an ADMIN * * ALTER INDEX REPLACE COLUMNS statement, * * resulting in a severe error. * **************************************************************** When the merge function processes ADMIN ALTER INDEX REPLACE COLUMNS for an index that has a blank in the column RELCREATED in SYSIBM.SYSINDEXES, it might incorrectly delete the wrong column records, resulting in an invalid version file. This invalid version file results in severe error ADB7955E later during the comparison. KEYWORDS: ADB7955E
Problem conclusion
The problem has been fixed.
Temporary fix
Comments
APAR Information
APAR number
PH60244
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
D10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2024-03-08
Closed date
2024-05-20
Last modified date
2024-06-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI96968
Modules/Macros
ADBCCMM
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RD10 PSY UI96968
UP24/06/03 P F405
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":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 June 2024