A fix is available
APAR status
Closed as unreproducible in next release.
Error description
Q Capture should check if the any source table columns have field procedures when it processes a CAPSTART signal. Q Capture checks if the source tables have any field procedures at start or reinit time and keeps this information in memory. If a subscription for a source table with a field procedure is activated, it is handled as a table without field procedures until Q Capture is recycled or a REINIT is issued. This causes incorrect data to be replicated or published.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1- Q Apply * * 2- All Q Capture customers * * 3- All Q Capture customers * * 4- All Q Capture customers * **************************************************************** * PROBLEM DESCRIPTION: 1- In multi-uni configuration, * * dropping multiple columns followed by * * reorg of table may cause ASN7512E * * error in apply at same node when the * * drop column gets replicated round trip * * back from other node. * * 2- Q Capture REINIT of an active * * subscription issues ASN7341W and does * * not send a schema message to Q Apply. * * 3- Q Capture should check if the any * * source table columns have field * * procedures when it processes a * * CAPSTART signal. Q Capture checks if * * the source tables have any field * * procedures at start or reinit time and * * keeps this information in memory. If a * * subscription for a source table with a * * field procedure is activated, it is * * handled as a table without field * * procedures until Q Capture is recycled * * or a REINIT is issued. This causes * * incorrect data to be replicated or * * published. * * 4- Q Capture issues ASN7138W each time * * it initializes a delimited * * subscription that has a * * IBMQREP_SENDQUEUES message_codepage * * that is not 1208. * **************************************************************** * RECOMMENDATION: * **************************************************************** 1- Q Apply in a multi-uni configuration may not handle round trip replication of multiple ALTER TABLE DROP COLUMN ddls resulting in ASN7512E error reported with Reason Code 4 or 6. 2- Q Capture REINIT should issue ASN7341W if the subscription STATE is 'L' and the subscription HAS_LOADPHASE is 'E'. 3- Q Capture should check if the any source table columns have field procedures when it processes a CAPSTART signal. 4- Q Capture should not issue ASN7138W.
Problem conclusion
Temporary fix
Comments
1- Q Apply will tolerate missing target columns while processing SCHEMA messages sent during replication of multiple ALTER TABLE DROP COLUMN ddl operation and avoid failing the subscription with ASN7512E. 2- Q Capture REINIT will issue ASN7341W only if the subscription STATE is 'L' and the subscription HAS_LOADPHASE is 'E'. 3- Q Capture will check if the any source table columns have field procedures when it processes a CAPSTART signal. 4- Q Capture REINIT will not issue ASN7138W. ASNCLP was not updated.
APAR Information
APAR number
PH07326
Reported component name
WS REPLICATION
Reported component ID
5655L8800
Reported release
A21
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-01-15
Closed date
2019-02-14
Last modified date
2019-03-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI61303 UI61304 UI61305 UI61306
Modules/Macros
ASNACMD ASNADMSP ASNAPPLY ASNCAP ASNCCMD ASNMCMD ASNMON ASNQACMD ASNQAPP ASNQASUB ASNQCAP ASNQCCMD ASNQDEP ASNQEXRP ASNQMFMT ASNQXFMT ASNRBASE ASNSQLCZ ASNTDIFF ASNTDSP ASNTRC ASN2BASE ASN2SQLZ
Fix information
Fixed component name
WS REPLICATION
Fixed component ID
5655L8800
Applicable component levels
RA21 PSY UI61303
UP19/02/26 P F902
RA24 PSY UI61304
UP19/02/26 P F902
RA25 PSY UI61305
UP19/02/26 P F902
RA26 PSY UI61306
UP19/02/26 P F902
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A21","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 March 2019