Create a text search index

You can create a text search index by calling the SYSPROC.SYSTS_CREATE stored procedure.

The DB2® base table must contain a ROWID column, unique key, or primary key.

To create a text search index on an existing DB2 table with a column that contains text:

Call the SYSPROC.SYSTS_CREATE stored procedure.

The text search index is empty until the first time that you update the index.