home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC70766 Status: Closed

DB2TEXT CREATE INDEX GETS ERROR: CTE0101 A SEARCH ENGINE OPERATION FAILED.
REASON CODE 112 OPTION: BLOCKMODE ....

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
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList