Text search index creation and updates

Text search index creation is the process of defining and declaring the properties of the text search index. Text search index update is the process of adding new data from a Db2 table to the text search index on the text search server and propagating any changes of the data.

For each text search index that you create, a new collection is created on the text search server. After initial creation, the text search index contains no data. You add data to the text search index by running a program that calls the SYSPROC.SYSTS_UPDATE stored procedure. The first update process adds all of the text documents from the text column to the text search index. This process is known as the initial update. The subsequent updates are incremental.