A fix is available
APAR status
Closed as program error.
Error description
Qcapture when using the ignore transaction feature can flood the IBMQREP_IGNTRANTRC table. Qcapture inserts a row into the IBMQREP_IGNTRANTRC for each transaction ignored. Qcapture ignores transactions that satisfy criteria set by the customer in the IBMQREP_IGNTRAN table. If the critera causes Qcapture to ignore thousands of rows then thousands of rows are inserted into the IBMQREP_IGNTRANTRC as documentation. This APAR will provide an option to tell Qcapture whether or not to insert rows into the IBMQREP_IGNTRANTRC. Qcapture can appear unresponsive as it goes into a prune cyle of the IBMQREP_IGNTRANTRC. The option to insert rows into IBMQREP_IGNTRANTRC will be made available through a new column in the IBMQREP_IGNTRAN table.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1- Q Capture customers who use the ignore * * transaction feature * **************************************************************** * PROBLEM DESCRIPTION: 1- Q Capture inserts a row into its * * IBMQREP_IGNTRANTRC table each time it * * ignores a transaction. Q Capture * * ignores transactions that satisfy * * exclusion criteria which is specified * * in its IBMQREP_IGNTRAN table. Q * * Capture inserts thousands of rows into * * its IBMQREP_IGNTRANTRC table if its * * exclusion criteria causes it to ignore * * thousands of transactions. * **************************************************************** * RECOMMENDATION: * **************************************************************** 1- Q Capture should insert rows into its IBMQREP_IGNTRANTRC table on a transaction exclusion criteria basis.
Problem conclusion
1- Provide an option to specify whether or not Q Capture will insert a row into its IBMQREP_IGNTRANTRC table each time it ignores a transaction. The option will be specified using a new IBMQREP_IGNTRAN table column. The ALTER TABLE syntax: ALTER TABLE ASN.IBMQREP_IGNTRAN ADD IGNTRANTRC CHAR(1) NOT NULL DEFAULT 'Y'; For each row in the IBMQREP_TRAN table, specify 'Y' for the IGNTRANTRC column to enable tracing for the ignored transaction based on the criteria. Otherwise, specify 'N' to disable tracing.
Temporary fix
Comments
APAR Information
APAR number
PK44946
Reported component name
WS REPLICATION
Reported component ID
5655L8800
Reported release
820
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-05-10
Closed date
2007-05-12
Last modified date
2007-06-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK25040 UK25041 UK25042 UK25043
Modules/Macros
ASNACMD ASNADMSP ASNAPPLY ASNCAP ASNCCMD ASNMCMD ASNMIG8 ASNMON ASNPLXFY ASNQACMD ASNQAPP ASNQCAP ASNQCCMD ASNQDEP ASNQMFMT ASNQXFMT ASNRBASE ASNSQLCF ASNTDIFF ASNTRC ASNTREP ASNTXS
Fix information
Fixed component name
WS REPLICATION
Fixed component ID
5655L8800
Applicable component levels
R820 PSY UK25040
UP07/05/23 P F705
R821 PSY UK25041
UP07/05/23 P F705
R822 PSY UK25042
UP07/05/23 P F705
R823 PSY UK25043
UP07/05/23 P F705
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":"820","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 June 2007