PH50592: Q Apply may fail with SQL -312 when using MRI with inserts having automatic RTRIM of char to varchar columns

Obtain the fix for this APAR.

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 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.