Update a text search index

You can update a text search index by calling the SYSPROC.SYSTS_UPDATE stored procedure.

The SYSTS_UPDATE call is used to initially populate the text search index. It is also used any time the contents of the DB2® table changes and you want to synchronize the text search index to those changes.

After a text search index update occurs, you can perform search queries on the text search index. The base table text search column can be changed after the update. In this case, the search query results do not reflect those changes until the next text search index update is run.