SYSIBMTS.TSDEFAULTS view
SYSIBMTS.TSDEFAULTS displays all the default values for all text search indexes in a database.
The default values are available as attribute-value pairs in this view.
| Column name | Data type | Nullable? | Description |
|---|---|---|---|
| DEFAULTNAME | VARCHAR (30) | NO | Database default parameters for text search |
| DEFAULTVALUE | VARCHAR (512) | NO | Values for database default parameters for text search |
The following values are used as defaults for the db2ts CREATE
INDEX, ALTER INDEX, UPDATE INDEX,
and CLEAR EVENTS FOR INDEX commands:
- AUXLOGNORM: The staging infrastructure can be enabled for a text search index with explicit index configuration AUXLOG ON. Do not enable the extended text-maintained staging infrastructure for non-partitioned tables by default.
- AUXLOGPART: The staging infrastructure can be disabled for a text index with explicit index configuration AUXLOG OFF. By default, enable the extended text-maintained staging infrastructure for range-partitioned tables.
- CJKSEGMENTATION: Specifies the segmentation method to use when indexing documents for Chinese, Japanese and Korean languages. The supported value includes: MORPHOLOGICAL and NGRAM. The default value is NGRAM.
- CODEPAGE: The initial default code page for new indexes is the database code page.
- DOCUMENTRESULTQUEUESIZE: This value is used to limit how much database memory is reserved per update operation for a collection. The default value is 30,000 while the range is 100 - 100,000. Note that on a multi-partition setup, a single text index update that is configured for parallel execution will reserve memory space for each collection that needs an update.
- FORMAT: The initial default for the document format is plain text.
- LANGUAGE: The initial default for document indexing is en_US.
- MAXCONCURRENTUPDATES: Controls the number of collection updates that can be executed in parallel at any given time. For multiple partition setups, the number of collections for each text index is determined according to the table distribution. However, only active partition updates count. The default is 8.
- MAXCONCURRENTCOLLECTIONS: Controls the number of collections that can be created. For a single-node database, the number of collections equals the number of text indexes, for multi-partition setups, the number of collections per text index matches the table distribution. The default is 160.
- MAXDOCUMENTSIZEINMB: Controls the size of documents that are accepted for processing. A text that exceeds the limit will result in a warning message in the event table. The value is 100.
- UPDATEFREQUENCY: The initial default for the update schedule for new indexes is NONE.
- UPDATEMINIMUM: The initial default for updating new indexes is 1, meaning that incremental updates can be done after every change.
- UPDATEAUTOCOMMIT: The initial default for updating new indexes is 0, meaning that there will be no intermediate commits when documents are read from Db2® text columns. This value is reserved, and you cannot change it.
You cannot use db2ts commands to change the default values at the database level.