SYSIBMTS.TSCONFIGURATION view
Information about index configuration parameters is available in the SYSIBMTS.TSCONFIGURATION view.
Each row represents a configuration parameter of the text search index.
Following is an example of a query against the
view that uses the index name:
db2 "SELECT VALUE from SYSIBMTS.TSCONFIGURATION where INDSCHEMA=schema-name
and INDNAME=ind-name and PARAMETER ='parameter'" | Column name | Data type | Nullable? | Description |
|---|---|---|---|
| INDSCHEMA | VARCHAR(128) | NO | Schema name of the text search index |
| INDNAME | VARCHAR(128) | NO | Unqualified name of the text search index |
| PARAMETER | VARCHAR(30) | NO | Name of a configuration parameter |
| VALUE | VARCHAR(512) | NO | Value of the parameter |
The PARAMETER column contains the names of the text search index configuration parameters specified with the CREATE INDEX statement and the names of some of the parameters from the SYSIBMTS.TSDEFAULTS view.