IBM Support

IC74041: "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

  • The Upperlimit of MaskResolutionLimit parameter is increased to
    sp that customers can recieve complete result set without
    truncation/error.
    

Problem conclusion

  • Upgrade to V97fp4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC74041

  • Reported component name

    DB2 NET SEARCH

  • Reported component ID

    5765F3803

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-01-25

  • Closed date

    2011-05-03

  • Last modified date

    2011-05-03

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

    IC73112

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

Fix information

  • Fixed component name

    DB2 NET SEARCH

  • Fixed component ID

    5765F3803

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows
OTHER - Uncategorised

Software version: 970

Reference #: IC74041

Modified date: 03 May 2011