A fix is available
APAR status
Closed as new function.
Error description
Q Apply may fail with SQL -312 when using MRI with inserts having automatic RTRIM of char to varchar columns.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1- All Q Capture users * * 2- Q Apply * * 3- All Q Capture users * **************************************************************** * PROBLEM DESCRIPTION: 1- Q Capture source on Db2 v11 did not * * work after customer migrated Db2 on * * proxy systems to V12 * * 2- Q Apply may fail with SQL -312 when * * using MRI with inserts having * * automatic RTRIM of char to varchar * * columns. * * 3- Q Capture parameter * * IFI_FILTER_PARTS does not work * * correctly * **************************************************************** 1- Partitioned tables on Db2 v11 are not replicated after Db2 on proxy system migrated to V12. 2- Q Apply started with RTRIM_CHAR_TO_VARCHAR=Y may fail with SQL -312 when using MRI with inserts having automatic RTRIM of char to varchar columns. 3- IFI_FILTER_PARTS=N is ignored by Q Capture when the source is Db2 V13
Problem conclusion
1- Extract the partition number from the log record header for any version of Db2 log records. If this is a V12 log reader, and the partition number is not supplied in the LRH, it is either because the table is not partitioned or we are in proxy mode and the source is down-level. 2- Q Apply will disable MRI for a table subscription if inserts use automatic RTRIM for char to varchar column mappings. 3- The Capture code is changed to respect the value for IFI_FILTER_PARTS if set. When loading the parm from CAPPARMS, if the value is null, then by default it will be set to Y if V13, or N if V12. ASNCLP was not updated. Function Level: 1140.103
Temporary fix
Comments
APAR Information
APAR number
PH50592
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
2022-11-01
Closed date
2022-12-15
Last modified date
2023-01-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI83772 UI83773 UI83774 UI83775
Modules/Macros
ASN2BASE ASNAAPP ASNACMD ASNACMP ASNADMSP ASNAFET ASNAISO ASNAMAN ASNAPPLY ASNAPRS ASNAWPN ASNCAP ASNCATM ASNCCMD ASNMCMD ASNMON ASNQACMD ASNQAPP ASNQAROW ASNQASUB 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 UI83772
UP22/12/17 P F212
RB34 PSY UI83773
UP22/12/20 P F212
RB35 PSY UI83774
UP22/12/17 P F212
RB36 PSY UI83775
UP22/12/17 P F212
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":"BU029","label":"Software"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B33"}]
Document Information
Modified date:
05 January 2023