DB2 - Problem description
Problem IC68767 | Status: Closed |
"CTE0360 "SEARCH RESULT TRUNCATED" | |
product: | |
DB2 NET SEARCH / 5765F3803 / 950 - DB2 | |
Problem 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 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All DB2+ NSE Users and Content Manager Users * **************************************************************** * PROBLEM DESCRIPTION: * * The configuration parameter MaskResolutionLimit is not * * correctly read from the configuration file during the query * * time. The parameter MaskResolutionLimit limits the wild card * * expansions when performing a wild card search using NSE. * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM DB2 Net Search Extender V.9.5.0.6 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Solution | |
The problem is fixed in IBM DB2 Net Search Extender V.9.5.0.6 | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC68777 IC68788 IC73061 IC73062 IC73063 IC73112 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.05.2010 09.09.2010 09.09.2010 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |