Updating a text search index

The Db2 database administrator runs a program that calls the SYSPROC.SYSTS_UPDATE stored procedure to update a text search index.

Procedure

To synchronize the text search index with the contents of the Db2 table:

Run a program that calls the SYSPROC.SYSTS_UPDATE stored procedure.

Example

The following example shows a sample program that updates a text search index by calling the SYSPROC.SYSTS_UPDATE stored procedure:
CALL SYSPROC.SYSTS_UPDATE('IXSCHEMA', 'IXNAME', ' ');

What to do next

Now, you can perform search queries on the text search index.