Fixes are available
APAR status
Closed as new function.
Error description
Ignore unchanged LOB/XML for UPDATEs using existing modified offset in P2P only.
Local fix
Problem summary
Problem Description: LOB/XML columns are updated at the target even if they were not changed at the source in P2P subscriptions and Bidir/Unidir subscriptions with conflict_action F. . User Affected: QCAPTURE / QAPPLY . Problem Summary: LOB/XML columns are unnecessarily updated at the target even if the actual data was not updated with the same change at the source. For example, a non-key non-LOB/XML update at the source would result in an update of non-key non-LOB/XML column as well as all LOB/XML columns in the table. This is caused by Apply's inability to determine if the LOB/XML value was changed at the source. LOB/XML values are always sent by Capture to resolve possible conflicts. For non-LOB/XML columns Apply can determine whether or not these columns have been updated at the source. . Problem Conclusion: Apply is able to determine if a LOB/XML column was updated at the source. If it was not updated the LOB/XML column is not included in the update at the target.
Problem conclusion
The problem has been fixed and will be available in DB2 LUW V9.5 FP9.
Temporary fix
Comments
APAR Information
APAR number
JR42022
Reported component name
WS Q-REPLIC LUW
Reported component ID
5724N9801
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-02-22
Closed date
2012-02-22
Last modified date
2012-02-22
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
WS Q-REPLIC LUW
Fixed component ID
5724N9801
Applicable component levels
R950 PSY
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5"}]
Document Information
Modified date:
07 October 2021