A fix is available
APAR status
Closed as unreproducible in next release.
Error description
Q Apply activates a Q subscription after it attempts to load the target table and the load fails.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1- All SQL Apply customers. * * 2- All Q Apply customers. * * 3- Q Apply * **************************************************************** * PROBLEM DESCRIPTION: 1- The SQL Apply ASNLOAD exit calls * * the Db2 SYSPROC.DSNUTILS stored * * procedure to run Db2 utilities (LOAD, * * REPAIR). * * 2- Q Apply activates a Q subscription * * after it attempts to load the target * * table and the load fails. * * 3- Q Apply agents interrupted for * * program stop may commit a partially * * applied transaction if it encounters a * * rare race condition in message logging * * shutdown logic and attempts to * * directly issue a ASN message into * * IBMQREP_APPLYTRACE table and commit. * **************************************************************** * RECOMMENDATION: * **************************************************************** 1- The SQL Apply ASNLOAD exit needs to be changed to call either the Db2 SYSPROC.DSNUTILU stored procedure or the Db2 SYSPROC.DSNUTILS stored procedure to run Db2 utilities (LOAD, REPAIR). 2- The Q Apply load function is not returning the Db2 load utility return code. 3- During Q Apply program stop, race conditions in msgLogger disable code may lead to Apply agents with partially applied transaction to issue commit instead of rollback if an ASN message gets issued to APPLYTRACE table.
Problem conclusion
Temporary fix
Comments
1- The SQL Apply ASNLOAD exit has been changed to call either the SYSPROC.DSNUTILS or SYSPROC.DSNUTILU stored procedure to run Db2 utilities (LOAD, REPAIR). 2- The Q Apply load function has been changed to return the Db2 load utility return code. 3- Q Apply stop processing is fixed to avoid agents with partial transactions from directly issuing ASN messages into IBMQREP_APPLYTRACE table or doing commit. Note: ASNCLP has been updated from db2_v105fp11 n180809.
APAR Information
APAR number
PH00518
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
2018-07-13
Closed date
2018-08-15
Last modified date
2018-09-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI57892 UI57893 UI57894 UI57895
Modules/Macros
ASNAAPP ASNACMD ASNACMP ASNADMSP ASNAFET ASNAISO ASNAMAN ASNAPP ASNAPPLY ASNAPRS ASNAWPN ASNBNDDR ASNBNDSR ASNBPXB ASNCAP 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 ASNISLKM ASNISMKD ASNITIT ASNJAJP ASNKOKR ASNLKMSG ASNLOAD ASNMCMD ASNMDATA ASNMKDIR 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 ASNQMZ10 ASNQNMIH ASNQPROF ASNQP2PA ASNQP2PI ASNQSPC ASNQSPIL ASNQSPS ASNQSQLZ ASNQXFMT ASNQZV10 ASNQ1001 ASNQ1021 ASNRBASE ASNRURU ASNSFALL ASNSMZ10 ASNSQLCZ ASNSVSE ASNS1001 ASNS1021 ASNTDIFF ASNTDSP ASNTDSQL ASNTRC ASNUOW ASNVCD ASNVMON ASNVREOR ASNVSQL ASNV1001 ASNV1021 ASNZHCN ASNZHTW ASNZOSCN ASN2BASE ASN2DBCN ASN2DB2C ASN2DB2Q ASN2SQLZ ASN2ZOSC
Fix information
Fixed component name
WS REPLICATION
Fixed component ID
5655L8800
Applicable component levels
RA21 PSY UI57892
UP18/08/24 P F808
RA24 PSY UI57893
UP18/08/24 P F808
RA25 PSY UI57894
UP18/08/24 P F808
RA26 PSY UI57895
UP18/08/24 P F808
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:
04 September 2018