SYSIBMTS.SYSTEXTCONFIGURATION administration table

The SYSIBMTS.SYSTEXTCONFIGURATION administration table contains information about the configuration parameters for the text search index as passed by the SYSPROC.SYSTS_CREATE stored procedure.

The following table shows the contents of the SYSIBMTS.SYSTEXTCONFIGURATION administration table. The primary key is the INDEXID column in conjunction with the PARAMETER column. The foreign key is the INDEXID column.

Table 1. Contents of the SYSIBMTS.SYSTEXTCONFIGURATION administration table
Column name Data type Nullable? Description
INDEXID INTEGER No Uniquely generated index ID for the text search index.
PARAMETER VARCHAR(30) No Parameters that are specified for the text search index in the SYSPROC.SYSTS_CREATE stored procedure.
VALUE VARCHAR(512) No Values for the specified parameters.