A fix is available
APAR status
Closed as program error.
Error description
Capture sends corrupted message when replicating same source table to multiple targets in multiple send queues. Example table T1 going to table T2, T3 and T4 in SENDQ1 and T1 going to TGT2, TGT3 and TGT4 in SENDQ2.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1- All Capture users * * 2- all users using zv1140 * **************************************************************** * PROBLEM DESCRIPTION: 1- Capture misses the updates to the * * clone * * 2- Capture sends corrupted message * * when replicating same source table to * * multiple targets in multiple send * * queues. Example table T1 going to * * table T2, T3 and T4 in SENDQ1 and T1 * * going to TGT2, TGT3 and TGT4 in SENDQ2. * **************************************************************** * RECOMMENDATION: * **************************************************************** 1- Currently Capture only passes the psid of the base table to IFI filter and Capture misses the updates to the clone. 2- queue sub has a pointer to its current row message in mq buffer of sendqueue, the initial buffer size is 16KB. If the transaction message exceeds 16KB, capture resizes the mq buffer. However in this step, capture doesn't reset the pointer of queue sub.
Problem conclusion
1- For base table with a clone table, the user must specify IFI_FILTER_ADD_CLONE_PSID=Y (run time parm) in order to capture the changes for the clone. Otherwise, the updates will be missed. The default for IFI_FILTER_ADD_CLONE_PSID=N for now. It will change in the future. 2- with this fix, capture resets message pointer of queue sub after the mq buffer is resized. ASNCLP was not updated. Function Level: 1140.103
Temporary fix
Comments
APAR Information
APAR number
PH34515
Reported component name
WS REPLICATION
Reported component ID
5655L8800
Reported release
B33
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-02-15
Closed date
2021-02-18
Last modified date
2021-04-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI74053 UI74054 UI74055 UI74056
Modules/Macros
ASNACMD ASNADMSP ASNAPPLY ASNCAP ASNCATM ASNCCMD ASNMCMD ASNMON ASNQACMD ASNQAPP ASNQCAP ASNQCCMD ASNQDEP ASNQEXRP ASNQMFMT ASNQXFMT ASNRBASE ASNTDIFF ASNTDSP ASNTRC ASN2BASE
Fix information
Fixed component name
WS REPLICATION
Fixed component ID
5655L8800
Applicable component levels
RB33 PSY UI74053
UP21/03/02 P F103
RB34 PSY UI74054
UP21/03/03 P F103
RB35 PSY UI74055
UP21/03/02 P F103
RB36 PSY UI74056
UP21/03/02 P F103
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":"SSDP5R","label":"InfoSphere Replication Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B33"}]
Document Information
Modified date:
02 April 2021