PH67672: Q Capture does not ignore trailing blanks in search condition string comparisons for char columns in APAR PH66621.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Q Capture does not ignore trailing blanks in search
  condition string comparisons for char columns in APAR PH66621.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- Customers with Db2 function level         *
  *                 greater than V12R1M502.                      *
  *                 2- All of the users have LOB in the          *
  *                 transaction and CAPPARMS LOB_SEND_OPTION is  *
  *                 'S'.                                         *
  *                 3- Users using search conditions for CHAR    *
  *                 columns                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1-                                      *
  *                      SET_MAINT_MODE_RECORD_NO_TEMPORALHISTOR *
  *                      Y storedProc is deprecated at           *
  *                      V12R1M503. But QApply is still calling  *
  *                      this stored procedure when there is a   *
  *                      temporal tables are replicated even in  *
  *                      db2 function level is V12R1M503. This   *
  *                      leads to DB2 to log warning message in  *
  *                      the diagnostic logs.                    *
  *                      2- If a transaction contains a DDL,     *
  *                      capture sends LOB separately after the  *
  *                      DDL message if LOB_SEND_OPTION is       *
  *                      'S'.This behavior causes Q Apply to     *
  *                      hang.                                   *
  *                      3- Q Capture should ignore trailing     *
  *                      blanks in search condition string       *
  *                      comparisons                             *
  ****************************************************************
  1- SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY storedProc is
  deprecated at V12R1M503, but QApply is still executing this
  stored procedure when there is a temporal table is replicated.
  2- When LOB_SEND_OPTION is set to 'S', if there are any rows in
  the transaction before the DDL, these rows are first replicated
  as a partial transaction, followed by a separate LOB message.
  3- When using a WHERE clause to filter rows, db2 ignores
  trailing blanks Q Capture should behave the same way.This is
  regression introduced in APAR  PH66621.
  

Problem conclusion

• 1- QApply  will set  SYSIBMADM.REPLICATION_OVERRIDE='Y' when
  the DB2 FL is V12R1M503 higher and will not call
  SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY storedProc
  2- If there is a DDL in the middle of the transaction with
  changes to LOB columns, capture will send a partial transaction
  message followed by separate LOB message before sending DDL
  message.
  3- Q Capture will ignore trailing blanks in search condition
  string comparisons.
  Note: ASNCLP has been updated from v1159 s2509260839.
  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:

  UO05162 UO05163 UO05164 UO05165

Modules/Macros

• ASN2BASE ASN2DB2C ASN2DB2Q ASN2DBCN ASN2SQLZ ASN2ZOSC ASNAAPP
  ASNACMD  ASNACMP  ASNADMSP ASNAFET  ASNAISO  ASNAMAN  ASNAPP
  ASNAPPLY ASNAPRS  ASNAWPN  ASNBNDDR ASNBNDSR ASNBPXB  ASNCAP
  ASNCATM  ASNCCDA  ASNCCDD  ASNCCMD  ASNCCPWK ASNCDA   ASNCDD
  ASNCDINS ASNCLP   ASNCLPAP ASNCLPB  ASNCLPCL ASNCLPCM ASNCLPCO
  ASNCLPCT ASNCLPEV ASNCLPMS ASNCLPQA ASNCLPRM ASNCMPLD ASNCSCZ
  ASNCTLZD ASNDADK  ASNDB2CN ASNDB2SQ ASNDBCON ASNDEDE  ASNDONE
  ASNENUP  ASNENUS  ASNESES  ASNFIFI  ASNFRFR  ASNITIT  ASNJAJP
  ASNKOKR  ASNLOAD  ASNMCMD  ASNMDATA ASNMON   ASNMONIT ASNMPROC
  ASNMUPDT ASNNONO  ASNPLPL  ASNPRUNE ASNPTBR  ASNQ1021 ASNQ1140
  ASNQACMD ASNQAHKT ASNQAPAG ASNQAPP  ASNQAROW ASNQASUB ASNQBNDE
  ASNQBNDL ASNQBNDR ASNQBNDT ASNQBRWZ ASNQCAP  ASNQCCDA ASNQCCDD
  ASNQCCMD ASNQCTLZ ASNQDEFQ ASNQDEP  ASNQEXRP ASNQFALL ASNQJ001
  ASNQJ002 ASNQLODZ ASNQMFMT ASNQMSTP ASNQNMIH ASNQP2PA ASNQP2PI
  ASNQPROF ASNQSPC  ASNQSPIL ASNQSPS  ASNQSQLZ ASNQXFMT ASNRBASE
  ASNRURU  ASNS1021 ASNSFALL ASNSQLCZ ASNSVSE  ASNTDIFF ASNTDSP
  ASNTDSQL ASNTRC   ASNUOW   ASNV1021 ASNV1140 ASNVCD   ASNVMON
  ASNVREOR ASNVSQL  ASNZHCN  ASNZHTW  ASNZOSCN
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RB33 PSY UO05162

     UP25/10/03 P F510

• RB34 PSY UO05163

     UP25/10/04 P F510

• RB35 PSY UO05164

     UP25/10/04 P F510

• RB36 PSY UO05165

     UP25/10/04 P F510

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.