A fix is available
APAR status
Closed as program error.
Error description
When altering an index the following errors occur Register failed and when hitting pf1 Reason Code = 20, Reason: Failed while building the delta version. The change file generated is missing an ALTER INDEX <index name> statement for the new column. This causes a register error since you are trying to pass invalid DDL.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Object Comparison Tool * * for z/OS who alter indexes. * **************************************************************** * PROBLEM DESCRIPTION: Registering a change that is trying to * * add a column to an index might fail * * with the following error: * * * * ADBC030E Register Failed * * Reason Code = 20, Reason: * * Failed while building the delta * * version. * **************************************************************** Compare creates a change file that is missing an ALTER INDEX statement. This condition occurs after a REORG utility statement is added due to altering the COMPRESS attribute of the index. Upon registering this change, the following error might occur: ADBC030E Register Failed Reason Code = 20, Reason: Failed while building the delta version.
Problem conclusion
The problem has been resolved. Search keywords: MSGADBC0303E MSGADBC030
Temporary fix
Comments
APAR Information
APAR number
PH28117
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
2020-08-05
Closed date
2020-10-25
Last modified date
2020-11-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI72226
Modules/Macros
ADB2CME
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RC10 PSY UI72226
UP20/11/02 P F010
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0"}]
Document Information
Modified date:
12 February 2021