Asynchronous indexing and triggers

Because updating a text search index is an extensive operation, the text search index that is maintained on the text search server is not updated synchronously when the Db2 table is updated.

Instead, changes to the Db2 table column are captured by triggers to a local log table. (Sometimes a log table might be referred to as a staging table.) These triggers automatically store information about new, changed, and deleted documents in a log table. One log table is associated with each text search index. Applying the contents of the log table to its corresponding text search index is called incremental update.

You can update the text search index that is on the text search server by invoking the SYSPROC.SYSTS_UPDATE stored procedure. You must periodically update the text search index in order for changes to be reflected in queries.