Text search administration tables

You can support your text search servers and indexes using the administration tables in QSYS2.

QSYS2.SYSTEXTDEFAULTS administration table
You can see the default parameters and values in the QSYS2.SYSTEXTDEFAULTS administration table. This table is created when you install OmniFind Text Search for DB2 for i.
QSYS2.SYSTEXTINDEXES administration table
You can see information about each text search index in the QSYS2.SYSTEXTINDEXES administration table. Each text search index has a name, schema name, and an associated collection name on the text search server.
QSYS2.SYSTEXTCOLUMNS administration table
You can see information about the text columns for a text search index in the QSYS2.SYSTEXTCOLUMNS administration table. Each text search index has an index ID, text column names, and the schema name of the base table.
QSYS2.SYSTEXTSERVERS administration table
You can see where the text search servers are installed using the QSYS2.SYSTEXTSERVERS administration table.
QSYS2.SYSTEXTCONFIGURATION administration table
You can see the configuration parameters for the text search index, as passed by the SYSPROC.SYSTS_CREATE stored procedure, in the QSYS2.SYSTEXTCONFIGURATION administration table.
QSYS2.SYSTEXTSERVERHISTORY administration table
You can see the history of servers used for the SYSPROC.SYSTS_DROP stored procedure by viewing the auxiliary table QSYS2.SYSTEXTSERVERHISTORY.
Text Search Index view
When a text search index is created with SYSTS_CREATE, a view representing the index will be created. Querying the text search index’s view can help the user obtain the status of the index. The text search index view’s name is same name as the text search index’s name that was specified while creating the index with SYSTS_CREATE.

Parent topic: OmniFind Text Search Server for DB2 for i