Incorrect Net Search Extender configuration

IBM® Content Collector text search support requires that all text indexes managed by Net Search Extender be created with specific index configuration settings. If these settings are not configured correctly, the text search result set might not be not complete, or might even be empty.

Symptoms

Incorrect settings can also lead to significant performance degradation and data loss. Therefore, it is essential that the index configuration is correct for each Net Search Extender full text index of each item type.
The following configuration options are essential because these options control how text is indexed and whether this text can be found again:
  • RESPECTCASE
  • TREATNUMBERSASWORDS
  • BLOCKMODE
These values are checked by the indexer for text search automatically. If they are not correctly configured in the Net Search Extender full text index configuration, the indexer issues one or more error messages with the following disclaimer:
A configuration or setup problem occurred:
The Net Search Extender index configuration is not as recommended and cannot be 
used with IBM Content Collector.
The Net Search Extender index must be re-created using a corrected 
Net Search Extender index configuration.
Modify the Net Search Extender index configuration template file 'cteixcfg.ini' 
in the Net Search Extender installation directory and then re-create the index. 
Net Search Extender will then copy the index configuration template file to the 
new index.

Causes

You cannot change the Net Search Extender index configuration after the full text index has been created. Also, Content Collector cannot correct Net Search Extender index configuration settings before the indexer uses these settings.

This restriction exists because, when an item type is created by using the IBM Content Collector initial configuration wizard or the IBM Content Collector set-up tool, it is created on the IBM Content Collector server machine and not on the machine on which IBM Content Manager and the Net Search Extender applications usually run.

This means that the tools that create the item type cannot access to the Net Search Extender index configuration template file called cteixcfg.ini. Configuration settings can only be checked after the full text index is created and the indexer is run on the item type. However, at that point in the process, it is too late to change a setting because the index is already created based on the settings in the template configuration file.

Resolving the problem

If a Net Search Extender full text index is created with incorrect configuration settings, the complete index must be re-created and rebuilt. To correct this problem, you must perform the following steps:
  1. Change the values of the index configuration options in the Net Search Extender index configuration template file to the recommended values. The Net Search Extender index configuration template file called cteixcfg.ini is located in the Net Search Extender installation directory (usually .../sqllib/db2ext).
  2. Re-create the Net Search Extender index by using the afuRecreateIndex tool.

    All items in the item type are reprocessed the next time that the afuIndexer process runs. Depending on the size of the item type, processing all items again can take a considerable amount of time.