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.