DB2 - Problem description
Problem IC70766 | Status: Closed |
DB2TEXT CREATE INDEX GETS ERROR: CTE0101 A SEARCH ENGINE OPERATION FAILED. | |
product: | |
DB2 NET SEARCH / 5765F3800 / 970 - DB2 | |
Problem description: | |
When BlockMode=YES in the cteixcfg.ini db2text create index for text gets the following error: db2text create index DB2EXT.COMMENT for text on DB2EXT.TEXTTAB (COMMENT) ATTRIBUTES (CAST(PRICE AS DOUBLE) AS PRICE) CACHE TABLE(docid,title) TEMPORARY MAXIMUM CACHE SIZE 100 CTE0101 A search engine operation failed. Reason code: "112", "100001", "0", "Option: BlockMode Section: IndexV4 ", "ItlClIndexConfig::onIndexFileInit, line 844". | |
Problem Summary: | |
The block mode configuration parameter valid values are wrongly mentioned in the index configuration file cteixfg.ini. | |
Local Fix: | |
It looks like there is a documentation error in the file cteixcfg.ini mentioning the valid values as "YES","DYNAMIC" and "NO". The Valid values for the parameter BlockMode are "ON","DYNAMIC" and "OFF". change BlockMode to a valid value: for example: BlockMode=ON | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Solution | |
The valid values are {"ON","DYNAMIC" and "OFF"}. The cteixfg.ini is updated in V97fp4. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 26.08.2010 03.05.2011 03.05.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP4 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.4 |
![]() |