Enhancement to the LIKE predicate

In Db2 11, enabling the new LIKE_BLANK_INSIGNIFICANT subsystem parameter enhances the LIKE predicate so that blanks at the end of fixed-length strings are ignored. Because of this new behavior, results for the LIKE predicate are more consistent regardless of whether the column data contains fixed-length strings or variable-length strings.

This behavior is called LIKE blank insignificant behavior. LIKE blank significant behavior, in which the blanks at the end of fixed-length strings are significant (not ignored), is the default behavior during installation or migration. For variable-length strings, blanks are significant.

Tip: After you enable the LIKE_BLANK_INSIGNIFICANT subsystem parameter, existing rows might not conform to table check constraints that contain a LIKE predicate. Consider running the CHECK DATA utility on all affected tables to find the records that do not conform to the table check constraint.