APAR status
Closed as program error.
Error description
IDR in some cases missed replicating manually added Oracle table partitions When it happens, new added partitions won't be recognized by CDC as in scope data (there is no indication in CDC instance log about this new partition creation) so that data in such partitions won't be replicated to target side.
Local fix
Upgrade to 11.4.0.3 5566 or above With a valid build installed, new partitions will be recognized by CDC(you will see such partition creation ddl detected in instance log and log reader will be restarted automatically) and data in it will be replicated as expected.
Problem summary
**************************************************************** * USERS AFFECTED: * * This issue may affect you if you are using CDC for LUW * * version older than 11.4.0.3-5566. * **************************************************************** * PROBLEM DESCRIPTION: * * IDR in some cases missed replicating manually added Oracle * * table partitions. * * * * When it happens, new added partitions won't be recognized by * * CDC as in scope data (there is no indication in CDC instance * * log about this new partition creation) so that data in such * * partitions won't be replicated to target side. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
Upgrading to IDR 11.4.0.3-5566 or newer for LUW resolves the issue.
Temporary fix
Comments
APAR Information
APAR number
JR62496
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-07-13
Closed date
2020-08-12
Last modified date
2020-08-12
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
[{"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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
13 August 2020