A fix is available
APAR status
Closed as program error.
Error description
ADBC002E SEVER ERROR IN MERGE, NO OBJECT ROW FOUND TO MATCH DELTA ROW - rowtype=KY.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Administration Tool for * * z/OS who analyze a change and the * * ADMIN ALTER INDEX statement has a * * quoted column name in the change. * **************************************************************** * PROBLEM DESCRIPTION: Analyzing a change ends with a * * ADBC002E / msgadbc002e error when * * the change contains an ADMIN ALTER * * INDEX statement with a quoted * * column name. * **************************************************************** * RECOMMENDATION: * **************************************************************** When a change contains an ADMIN ALTER INDEX statement with a quoted column name, upon performing an ALTER INDEX with column attribute operation, Merge fails to find matching column name due to the quotes around the column name and fails with the following error: ADBC002E severe error in merge, No object row found to match delta row- rowtype=KY.
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PI82533
Reported component name
DB2 OBJECT COMP
Reported component ID
5697G6400
Reported release
B20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-06-02
Closed date
2017-06-13
Last modified date
2017-07-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI48017
Modules/Macros
ADBCDTS ADB2CME
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RB20 PSY UI48017
UP17/06/15 P F706
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.2.0"}]
Document Information
Modified date:
18 March 2021