APAR status
Closed as program error.
Error description
When detecting a DDL, CDC raises event 9505, but the subscription stops mirroring without showing an error in MC.
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * This issue may affect you if you use IIDR 11.4.0.3-5569 or * * older as a source engine, and you alter tables while * * mirroring is active. * **************************************************************** * PROBLEM DESCRIPTION: * * When a subscription is running as Mirror/Active and a table * * being replicated is altered (such as "alter table add * * column"), then the subscription should end on error. Prior * * to this fix, the subscription was ending mirroring but the * * status was shown as "Inactive" instead of "Failed", and the * * event log did not contain an Error message. After this fix, * * the subscription ends mirroring with status "Failed", and * * logs an Error event. * **************************************************************** * RECOMMENDATION: * * Upgrade to IIDR 11.4.0.3-5570 or newer. * ****************************************************************
Problem conclusion
Upgrading to IIDR 11.4.0.3-5570 or newer resolves the issue.
Temporary fix
Comments
APAR Information
APAR number
JR62799
Reported component name
IS DATA REPLICA
Reported component ID
5725E3000
Reported release
B40
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-09-13
Closed date
2020-09-30
Last modified date
2020-09-30
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
IS DATA REPLICA
Fixed component ID
5725E3000
Applicable component levels
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.4"}]
Document Information
Modified date:
01 October 2020