DB2 FOR LUW / DB2FORLUW / B50 - DB2

If a customer is using masking characters in his queries (e.g.
%wa%), this will only provide non-truncated results based on a
higher value set for either the preconfigured
MaskResolutionLimit  or the search query parameter EXPANSION
LIMIT.

Currently the upper limit for MaskResolutionLimit parameter is
set to a too low value -10000. An upper limit of 10000 for
MaskResolutionLimit will not give the desired results .The limit
specifies the maximum number of terms that a wild card search
term can be expanded into for searching. This should be
increased to 500,000 so that the customer can receive the
complete result set without truncation/error.

****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.5m4fp0 or later                            *
****************************************************************

not known / see Local fix

forerunner  : IT09227 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

04.02.2020
30.06.2020
30.06.2020