A fix is available
APAR status
Closed as new function.
Error description
Dropping a source table for an active subscription caused erroneous behavior for Q Capture.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1- ALL Capture users * * 2- All Replication users * * 3- All Q Capture users * * 4- All Q Capture customers * **************************************************************** * PROBLEM DESCRIPTION: 1- Too many ASN0635I messages in the * * job log. * * 2- Replication tasks issued a SELECT * * from SYSIBM.SYSLEVELUPDATES table to * * check the DB2 level information. If * * the user did not have the right * * authority, the SQL statement returned * * SQLCODE -551. Subsequently the * * replication tasks also failed * * 3- Dropping a source table for an * * active subscription caused erroneous * * behavior for Q Capture. * * 4- Q Capture displays ASN0725W plus * * diagnostic data and continues * * executing after its log reader detects * * out of order log records. * **************************************************************** * RECOMMENDATION: * **************************************************************** 1- Currently Capture puts out an ASN0635I message for every row in IGNTRAN table. It will be too many messages in the job log if there are thousands of rows in IGNTRAN table. 2- Replication task failed when checking the SYSIBM.SYSLEVELUPDATES table for Db2 level information and the user did not have the right authority. 3- When a subscribed table is dropped, the user needs to tell Capture how to handle the subscription. 4- Q Capture will display ASN0725W plus diagnostic data, rollback uncommitted MQ transactions and reinitialize after its log reader detects out of order log records first time, display ASN0725W plus diagnostic data and stop after its log reader detects out of order log records second time if its REINIT_ON_OUTORDER_LOG is 'Y'. Q Capture will display ASN0725W plus diagnostic data and stop after the log reader detects out of order log records if its REINIT_ON_OUTORDER_LOG is 'N' (Default).
Problem conclusion
Temporary fix
Comments
1- Capture was fixed to suppress the ASN0635I message from the job log. It will only go to the .log. 2- Replication initialization is changed to ignore any SQL error when checking the SYSIBM.SYSLEVELUPDATES table for Db2 level information. 3- Q Capture will provide a new option "DROPTAB_ACTION" for user to specify the action that Q Capture should take when a subcribed table is dropped. 4- The Q Capture REINIT_ON_OUTORDER_LOG parameter has been added to prevent data loss the log reader detects out of order log records Note: ASNCLP has been updated from db2_v111m4fp6 s2004231900. Functional level: 1140.103
APAR Information
APAR number
PH23855
Reported component name
WS REPLICATION
Reported component ID
5655L8800
Reported release
B33
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2020-03-30
Closed date
2020-04-30
Last modified date
2020-06-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI69297 UI69298 UI69299 UI69300
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 UI69297
UP20/05/12 P F005
RB34 PSY UI69298
UP20/05/12 P F005
RB35 PSY UI69299
UP20/05/12 P F005
RB36 PSY UI69300
UP20/05/12 P F005
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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 June 2020