IT08235: INCORRECT RESULT COULD BE RETURNED WHEN USING FULLWIDTH UNDER- SCORE CHARACTER (X'EFBCBF') IN LIKE PREDICATE AGAINST CLOB DATA

DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Sometimes extra rows that do not qualify might be returned. This
  occurs when you use the fullwidth underscore character X'EFBCBF'
  in the LIKE predicate to match the CLOB datatype in the CLOB
  columns against Unicode databases, and the data's length is less
  than the pattern's length. This is because the fullwidth
  underscore character is 3 bytes.
  

Local fix

• Apply this fix or change to use single byte underscore.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users of Unicode databases                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 version 10.1.0.5.                             *
  ****************************************************************
  

Problem conclusion

• The problem is first fixed in DB2 version 10.1.0.5.
  

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:

  IT09614

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RA10 PSN

     UP