A fix is available
APAR status
Closed as new function.
Error description
Add CAPTUREUPTO as Q Capture startup parameter
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1- All users * * 2- all SQL Apply users * * 3- Users who want to use parameter * * CAPTUREUPTO * **************************************************************** * PROBLEM DESCRIPTION: 1- When customer got email alerts they * * need to open each email to see the * * detail information to see for which * * DB/SCHEMA/CONDITION name the warning * * message occurs. * * 2- SQL Apply high CPU consumption in * * ASNAISO after migration to DB2 V12 * * 3- Add CAPTUREUPTO as Q Capture * * startup parameter * **************************************************************** 1- Customer have to open the email to get details on DB/SCHEMA/CONDITION name the for the alert messages. 2- The CPU costs increased dramatically in apply after migration to DB2 V12. 3- Add CAPTUREUPTO as Q Capture startup parameter
Problem conclusion
1- The alert email subject is more detailed to include the server alias, schema, condition name and msg code. old subject: ASN5134I MONITOR "" : "WorkerThread". Alert issued. Msg Code ASN5153W new subject: ASN5134I MONITOR "" : "WorkerThread". Alert issued for server alias SERVER_ALIAS, schema SCHEMA_OR_QUAL, condition CONDITION_NAME. Msg Code ASN5153W 2- Change query to use INDEXONLY access. 3- Add CAPTUREUPTO as Q Capture startup parameter Note: ASNCLP has been updated from db2_v111m4fp7 s2106251900. Function Level: 1140.103
Temporary fix
Comments
APAR Information
APAR number
PH36439
Reported component name
WS REPLICATION
Reported component ID
5655L8800
Reported release
B33
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2021-04-19
Closed date
2021-06-29
Last modified date
2022-06-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI76135 UI76136 UI76137 UI76138
Modules/Macros
ASN2BASE ASNACMD ASNADMSP ASNAISO ASNAPPLY ASNCAP ASNCATM ASNCCMD ASNCLPAP ASNCLPCL ASNCLPCM ASNCLPCO ASNCLPMS ASNCLPQA ASNMCMD ASNMON ASNMUPDT ASNQACMD ASNQAPP ASNQCAP ASNQCCMD ASNQDEP ASNQEXRP ASNQMFMT ASNQXFMT ASNRBASE ASNTDIFF ASNTDSP ASNTRC
Fix information
Fixed component name
WS REPLICATION
Fixed component ID
5655L8800
Applicable component levels
RB33 PSY UI76135
UP21/07/07 P F107
RB34 PSY UI76136
UP21/08/02 P F107
RB35 PSY UI76137
UP21/08/02 P F107
RB36 PSY UI76138
UP21/07/07 P F107
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B33"}]
Document Information
Modified date:
11 June 2022