SYSIBMTS.SYSTEXTINDEXES administration table

The SYSIBMTS.SYSTEXTINDEXES administration table provides information about each text search index, such as the name and the schema name of the text search index and the name of the associated collection on the text search server.

The following table shows the contents of the SYSIBMTS.SYSTEXTINDEXES administration table. The unique key for this table is the INDEXID column in conjunction with the INDEXSCHEMA column. The primary key is the INDEXID column.

Table 1. Contents of the SYSIBMTS.SYSTEXTINDEXES administration table
Column name Data type Nullable? Description
INDEXID INTEGER No Uniquely generated index ID for the text search index.
INDEXSCHEMA VARCHAR(128) No Schema name for the text search index.
INDEXNAME VARCHAR(128) No Unqualified name of the text search index.
TABLESCHEMA VARCHAR(128) No Schema name of the base table.
TABLENAME VARCHAR(128) No Unqualified name of the base table.
COLLECTIONNAME VARCHAR(128) No Name of the associated collection on the text search server.
SERVERID INTEGER No The server ID for the text search index.
TAKEOVERSERVERID INTEGER Yes The server ID that a currently running SYSPROC.SYSTS_TAKEOVER or SYSPROC.SYSTS_RESTORE stored procedure is using to take over text search functions for the text search index. When the SYSPROC.SYSTS_TAKEOVER stored procedure is not running, this value is null.
TAKEOVERSERVERPULSE TIMESTAMP Yes The pulse that is used to monitor the progress of a takeover or restore operation.
SEARCHARGS VARBINARY(1024) Yes Reserved for future use.
ALIASSCHEMA VARCHAR(128) No The alias for the schema of the base table that was used in the SYSPROC.SYSTS_CREATE stored procedure. If no alias is used, this value is identical to TABLESCHEMA.
ALIASNAME VARCHAR(128) No The alias for the name of the base table that was used in the SYSPROC.SYSTS_CREATE stored procedure. If no alias is used, this value is identical to TABLENAME.
STAGINGTABLENAME VARCHAR(128) Yes The name of the log table for the text search index.
EVENTTABLENAME VARCHAR(128) No The name of the event table for the text search index.
OFINDEXTABLENAME VARCHAR(128) No The name of the table for the text search index on the text search server.
UPDATEMINIMUM INTEGER No Minimum number of entries in the log table before an incremental update of the text search index is performed.
UPDATEFREQUENCY VARCHAR(512) No The update frequency for the text search index as specified by the SYSPROC.SYSTS_CREATE stored procedure.
UPDATEMODE INTEGER No Indicates the update mode of the text search index. The integer 0 (zero) indicates the initial update of the text search index. A value of 1 indicates subsequent, incremental updates.
CREATETIME TIMESTAMP No The time that the text search index was created.
LASTUPDATETIME TIMESTAMP Yes The time that the text search index was last updated.
LASTUPDATESTATUS CHAR Yes Indicates the internal status for optimizing the clean-up process after an initial or incremental update of the text search index. The following values are supported:
  • C: If an initial update is run again, the collection must be cleared. No clean-up is required for an incremental update.
  • N: No clean-up is required for the incremental update.
  • U: Rows in the log table must be unmarked.
  • D: The specified rows in the log table must be deleted.
SCHEDULERTASKID INTEGER Yes Reserved for future use.
EXPRESSIONLISTS CLOB(32K) No Reserved for future use.
EXPRESSIONNUMBERS VARBINARY(32) No Reserved for future use.
USEREXITFUNCTION VARCHAR(18) Yes Reserved for future use.
REMARKS VARCHAR(512) Yes Remarks made in the COMMENTS option of the index-configuration-options parameter of the SYSPROC.SYSTS_CREATE stored procedure.