SYSIBMTS.SYSTEXTDEFAULTS administration table

The SYSIBMTS.SYSTEXTDEFAULTS administration table provides the default parameters and values for the database SYSIBMTA, which is created with schema SYSIBMTS when you enable text search support for Db2 for z/OS®.

The following table shows the contents of the SYSIBMTS.SYSTEXTDEFAULTS administration table.

Table 1. Contents of the SYSIBMTS.SYSTEXTDEFAULTS administration table
Column name Data type Nullable? Description
NAME VARCHAR(30) No Name of a default parameter for the database for text search.
VALUE VARCHAR(512) No Value for the default parameter for text search.
TYPE INTEGER No Reserved.