338 IBM Content Manager OnDemand Guide
15.2.3  Indexing document through FTS Exporter
New documents that are to be full text indexed are retrieved from Content Manager 
OnDemand by the FTS Exporter component. These documents are then pushed into the full 
text engine of the FTS Server. The detailed process is shown in Figure 15-2.
Figure 15-2   The role of the FTS Exporter in full text indexing
To support the FTS Server, a new table (arsftiwork) was created in the Content Manager 
OnDemand database. The arsftiwork table is used to hold full text indexing work items. 
Whenever a new document will be indexed, a work item record is created in the arsftiwork 
table as part of the Content Manager OnDemand load process. For existing data, this process 
occurs explicitly by using the command-line tools or the ODWEK Java API.
To index new documents, the FTS Exporter connects to the arsftiwork table and works 
through the records, retrieving the associated documents from the Content Manager 
OnDemand server and pushing them into the FTS Server to be indexed. Documents that are 
to be removed from the full text index follow the same process. The FTS Exporter handles all 
tasks that relate to adding, updating, and deleting documents to and from the full text index. 
The FTS Exporter application is a Java application that communicates with the Content 
Manager OnDemand server to retrieve the documents from the Content Manager OnDemand 
server and push the documents to the FTS.
15.2.4  Searching
Search queries are handled by the Content Manager OnDemand server by directly 
communicating with the FTS Server. When an FTS string is specified during a query in a 
Content Manager OnDemand folder, a query is issued to the FTS Server for all applicable 
collections that match the date range. If no date range is specified in the query, all collections 
for the specified application group are queried.
15.3  Planning and installing FTS
The following section describes the main aspects of the FTS component installation and 
configuration.
Retrieve the
documents
(ODWEK)
Send the
documents
for Indexing 
(FTS   API)
search
Full Text Search
(FTS) Exporter
arsftiwork
table
Write
Work items
Process
work items
(JDBC)
CMOD Server
 Full Text Search Server
Index