A fix is available
APAR status
Closed as new function.
Error description
Q Capture looping when q is full and using parallel mq thread
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1- All Capture users * * 2- All Capture users * * 3- Q Capture users * * 4- All SQL Apply users * **************************************************************** * PROBLEM DESCRIPTION: 1- Q Capture abended when decoding * * COMMENT statement * * 2- Q Capture support of Db2 z/OS * * IFI306 filter by partition range * * 3- Q Capture looping when q is full * * and using parallel mq thread * * 4- SQL Apply should retry using DELETE * * when TRUNCATE target table fails with * * sqlcode -150 * **************************************************************** 1- Q Capture abended when decoding COMMENT statement 2- Db2 z/OS has implemented a range partition filter in IFI 306. Q Capture is changed to use this enhancement to improve Capture program performance for subscriptions by range-partition. 3- Q Capture loops endlessly when running with parallel_mqthread=Y and hitting a qfull condition. 4- Currently, when performing a fullrefresh, the APPLY program will execute the TRUNCATE command
Problem conclusion
1- Capture is changed to check the column datatype of zero before decoding. 2- Q Capture is enhanced to pass the partition range in the filter when invoking IFI 306 for subscriptions by range-partition. There is no impact for regular subscriptions and it simply pass the values 0000. 3- Fixed the rc when the queue is full in a few places. 4- Apply should retry this operation with DELETE since VIEW is a supported target type. ASNCLP was not updated. Function Level: 1140.103
Temporary fix
Comments
APAR Information
APAR number
PH41040
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
2021-10-01
Closed date
2021-11-18
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:
UI78141 UI78142 UI78143 UI78144
Modules/Macros
ASN2BASE ASN2SQLZ ASNAAPP ASNACMD ASNADMSP ASNAPPLY ASNCAP ASNCATM ASNCCMD ASNMCMD ASNMON ASNQACMD ASNQAHKT ASNQAPAG ASNQAPP ASNQAROW ASNQBRWZ ASNQCAP ASNQCCMD ASNQDEP ASNQEXRP ASNQLODZ ASNQMFMT ASNQP2PI ASNQSPIL ASNQXFMT ASNRBASE ASNSQLCZ ASNTDIFF ASNTDSP ASNTRC
Fix information
Fixed component name
WS REPLICATION
Fixed component ID
5655L8800
Applicable component levels
RB33 PSY UI78141
UP21/11/30 P F111
RB34 PSY UI78142
UP21/12/01 P F111
RB35 PSY UI78143
UP21/11/30 P F111
RB36 PSY UI78144
UP21/12/01 P F111
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