IBM Support

IC68777: "CTE0360 "SEARCH RESULT TRUNCATED"

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Customer migrated from DB2 8.2 to 9.5.
    In the new environment we are currently seeing many more Full
    Text Searches getting the following error:
    SQL0443N  Routine "TEXTSEARCH_8K64" (specific name "CTE21") has
    returned an error SQLSTATE with diagnostic text "CTE0360
    "Search result truncated by mask limit."".  SQLSTATE=38960
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * "CTE0360 "SEARCH RESULT TRUNCATED" dur to mask limit         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V97fp3                                            *
    ****************************************************************
    

Problem conclusion

  • The configuration parameter MaskResolutionLimit is not
    correctly read from the configuration file during the query
    time. The parameter MaskResolutionLimit limits the wildcard
    expansions when performing a wildcard search using NSE.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC68777

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-05-26

  • Closed date

    2010-10-20

  • Last modified date

    2010-10-20

  • APAR is sysrouted FROM one or more of the following:

    IC68767

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7"}]

Document Information

Modified date:
10 September 2020