A fix is available
APAR status
Closed as new function.
Error description
Endless loop in SQL Capture, which appears to be hung.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1- All SQL Replication users who issue * * ALTER TABLE on tables registered for SQL * * replication. * **************************************************************** * PROBLEM DESCRIPTION: 1- Endless loop in SQL Capture, which * * appears to be hung. * **************************************************************** 1- SQL Capture is consuming CPU but not replicating anything.
Problem conclusion
1- Fixed incorrect check in loop condition. ASNCLP was not updated. Function Level: 1140.103
Temporary fix
Comments
APAR Information
APAR number
PH54531
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
2023-05-15
Closed date
2023-06-05
Last modified date
2023-07-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI92109 UI92110 UI92111 UI92112
Modules/Macros
ASN2BASE ASN2DB2C ASN2DB2Q ASN2DBCN ASN2SQLZ ASN2ZOSC 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 ASNDB2CN ASNDB2SQ ASNDBCON ASNDEDE ASNDONE ASNENUP ASNENUS ASNESES ASNFIFI ASNFRFR ASNITIT ASNJAJP ASNKOKR ASNLOAD ASNMCMD ASNMDATA ASNMON ASNMONIT ASNMPROC ASNMUPDT ASNNONO ASNPLPL ASNPRUNE ASNPTBR ASNQ1021 ASNQ1140 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 ASNQP2PA ASNQP2PI ASNQPROF ASNQSPC ASNQSPIL ASNQSPS ASNQSQLZ ASNQXFMT ASNRBASE ASNRURU ASNS1021 ASNSFALL ASNSQLCZ ASNSVSE ASNTDIFF ASNTDSP ASNTDSQL ASNTRC ASNUOW ASNV1021 ASNV1140 ASNVCD ASNVMON ASNVREOR ASNVSQL ASNZHCN ASNZHTW ASNZOSCN
Fix information
Fixed component name
WS REPLICATION
Fixed component ID
5655L8800
Applicable component levels
RB33 PSY UI92109
UP23/06/07 P F306
RB34 PSY UI92110
UP23/07/03 P F306
RB35 PSY UI92111
UP23/06/08 P F306
RB36 PSY UI92112
UP23/06/08 P F306
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":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M","label":"InfoSphere Replication Server"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"B33"}]
Document Information
Modified date:
03 July 2023