A fix is available
APAR status
Closed as unreproducible in next release.
Error description
Q Apply gets SQLCODE -803 when it replicates a DELETE operation from an archive-enabled table if it also replicates the associated archive table and the default for the Db2 SYSIBMADM.MOVE_TO_ARCHIVE built-in global variable is 'E' or 'Y'.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1- All Q Capture customers who publish * * messages encoded using MESSAGE_FORMAT 'E'. * * 2- All Q Capture customers who use the * * Replication NMI Server. * * 3- All Q Apply customers * * 4- All Q Capture customers who publish XML * * messages. * * 5- All Q Capture customers using * * bidirectional subscriptions, Db2 data * * sharing, and capture_load = R. * * 6- All Q Capture customers who publish XML * * messages. * **************************************************************** * PROBLEM DESCRIPTION: 1- Q Capture hangs in GETMAIN after it * * overlays the first byte of a heap free * * element. * * 2- The Q Capture NMI server sends * * active workload metrics messages to * * NMI clients. The Q Capture NMI server * * receives a SIGPIPE signal if it sends * * a message to an NMI client after the * * NMI client terminates. * * 3- Q Apply gets SQLCODE -803 when it * * replicates a DELETE operation from an * * archive-enabled table if it also * * replicates the associated archive * * table and the default for the Db2 * * SYSIBMADM.MOVE_TO_ARCHIVE built-in * * global variable is 'E' or 'Y'. * * 4- Q Capture XML format messages * * display invalid FLOAT data type values * * if the FLOAT data type value is zero. * * 5- Q Capture loops when it restarts a * * bidirectional subscription after it * * detects a Db2 LOAD operation for the * * source table if it uses Db2 data * * sharing. * * 6- The Q Capture XML format message * * cmitTime attribute value does not * * display microseconds if the value for * * microseconds is zero. * **************************************************************** * RECOMMENDATION: * **************************************************************** 1- The Q Capture MESSAGE_FORMAT 'E' buffer overlays the next heap element if Q Capture writes an intent_seq column at the end of the buffer. 2- The Q Capture NMI server should handle SIGPIPE signals. 3- Q Apply should be able to set the Db2 SYSIBMADM.MOVE_TO_ARCHIVE built-in global variable to 'N'. 4- The Q Capture XML format message should display zero for a FLOAT data type values if the FLOAT data type value is zero. 5- Q Capture loops validating the bidirectional subscription. 6- The Q Capture XML format message cmitTime attribute value should display microseconds if the value for microseconds is zero.
Problem conclusion
Temporary fix
Comments
1- Q Capture has been changed to fix this problem. 2- The Q Capture NMI server has been changed to handle SIGPIPE signals. 3- Q Apply has been changed to accept the ARCHIVE_DELETE start-up parameter. Q Apply will set the SYSIBMADM.MOVE_TO_ARCHIVE Db2 global variable to 'N' if the ARCHIVE_DELETE parameter is 'N'. 4- Q Capture has been changed to fix this problem. 5- Q Capture has been changed to fix this problem. Q Capture has also been changed to accept the NOWAIT_INTLOAD start-up parameter. The NOWAIT_INTLOAD start-up parameter tells the Q Capture program in a Db2 data sharing environment whether to start an internal load of the target table immediately, even if a long-running transaction that is holding the min_inflight has not been committed. This parameter is valid only if the Q subscription is defined with an internal load (IBMQREP_SUBS HAS_LOADPHASE='I'). 6- Q Capture has been changed to fix this problem. ASNCLP was not updated.
APAR Information
APAR number
PH02537
Reported component name
WS REPLICATION
Reported component ID
5655L8800
Reported release
B33
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-09-06
Closed date
2018-11-29
Last modified date
2019-01-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI60003 UI60004 UI60005 UI60006
Modules/Macros
ASNAAPP ASNACMD ASNACMP ASNADMSP ASNAFET ASNAISO ASNAMAN ASNAPP ASNAPPLY ASNAPRS ASNAWPN ASNBNDDR ASNBNDSR ASNBPXB ASNCAP ASNCATM ASNCCDA ASNCCDD ASNCCMD ASNCCPWK ASNCDA ASNCDD ASNCDINS ASNCLP ASNCLPAP ASNCLPB ASNCLPCL ASNCLPCM ASNCLPCO ASNCLPCT ASNCLPEV ASNCLPMS ASNCLPQA ASNCLPRM ASNCMPLD ASNCSCZ ASNCTLZD ASNDADK ASNDBCON ASNDB2CN ASNDB2SQ ASNDEDE ASNDONE ASNENUP ASNENUS ASNESES ASNFIFI ASNFRFR ASNITIT ASNJAJP ASNKOKR ASNLOAD ASNMCMD ASNMDATA ASNMON ASNMONIT ASNMPROC ASNMUPDT ASNNONO ASNPLPL ASNPRUNE ASNPTBR ASNQACMD ASNQAHKT ASNQAPAG ASNQAPP ASNQAROW ASNQASUB ASNQBNDE ASNQBNDL ASNQBNDR ASNQBNDT ASNQBRWZ ASNQCAP ASNQCCDA ASNQCCDD ASNQCCMD ASNQCTLZ ASNQDEFQ ASNQDEP ASNQEXRP ASNQFALL ASNQJ001 ASNQJ002 ASNQLODZ ASNQMFMT ASNQMSTP ASNQNMIH ASNQPROF ASNQP2PA ASNQP2PI ASNQSPC ASNQSPIL ASNQSPS ASNQSQLZ ASNQXFMT ASNQ1021 ASNQ1140 ASNRBASE ASNRURU ASNSFALL ASNSQLCZ ASNSVSE ASNS1021 ASNTDIFF ASNTDSP ASNTDSQL ASNTRC ASNUOW ASNVCD ASNVMON ASNVREOR ASNVSQL ASNV1021 ASNV1140 ASNZHCN ASNZHTW ASNZOSCN ASN2BASE ASN2DBCN ASN2DB2C ASN2DB2Q ASN2SQLZ ASN2ZOSC
Fix information
Fixed component name
WS REPLICATION
Fixed component ID
5655L8800
Applicable component levels
RB33 PSY UI60003
UP18/12/10 P F812
RB34 PSY UI60004
UP18/12/10 P F812
RB35 PSY UI60005
UP18/12/10 P F812
RB36 PSY UI60006
UP18/12/10 P F812
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":"B33","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
24 January 2019