I'm trying to use DB2 Text Search with DB2 9.7 on Windows
I tried creating and updating indexes on a sample database for text search and it works fine.
However, on increasing the number of rows in table between 25000 to 50000 rows , updating index for text search is giving issues.
It takes a lot of time and ends up with the following error:
SQL20427N An error occurred during a text search administration procedure or co
mmand. The error message is "CIE00341 Update index errors. See event view "SYSIB
In the event view the error message is as:
CIE00701 Internal error. Location: "1080", "2". CIE00701 Internal error. Location: "1084", "2".
What can be a possible solution to it .. ?Does it need some configuration changes.. ?
Pinned topic Unable to update text search index for a huge database
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-06-21T21:42:16Z at 2011-06-21T21:42:16Z by MarionBehnen
MarionBehnen 0600019YP24 Posts
Re: Unable to update text search index for a huge database2011-06-21T21:42:16ZThis is the accepted answer. This is the accepted answer.Hi, the first check is to review the TCP/IP settings, as depending on the system those might be insufficient. A description how to check/set those is on http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.ts.doc/doc/c0057192.html
If those settings are all fine, then it might be a memory/queue related issue and there are multiple configuration settings that can play a role here. Their usage differs depending on the version, can you therefore please provide the OS, the DB2 fixpack, and the version from the build_info.properties for the textserver?