QSYS2.SYSTEXTINDEXES administration table
You can see information about each text search index in the QSYS2.SYSTEXTINDEXES administration table. Each text search index has a name, schema name, and an associated collection name on the text search server.
The following table shows the contents of the QSYS2.SYSTEXTINDEXES administration table. The unique key for this table is the INDEXSCHEMA column with the INDEXNAME column. The primary key is the INDEXID column.
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. |
TABLEIASP | SMALLINT | No | Independent ASP of the base table. |
COLLECTIONNAME | VARCHAR(255) | 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 | Reserved for future use. |
TAKEOVERSERVERPULSE | TIMESTAMP | Yes | Reserved for future use. |
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 OmniFind Text Search Server for DB2® for i. |
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. |
REORGANIZATIONMODE | INTEGER | No | Indicates the reorganization mode of the text search index. |
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 cleanup process after an initial or incremental update of the
text search index. Typical values include:
|
SCHEDULERTASKID | INTEGER | Yes | Reserved for future use. |
EXPRESSIONLISTS | CLOB (32 K) | Yes | Reserved for future use. |
EXPRESSIONNUMBERS | VARBINARY(32) | Yes | Reserved for future use. |
USEREXITFUNCTION | VARCHAR(18) | Yes | Reserved for future use. |
REMARKS | VARCHAR(2000) | Yes | Remarks made in the COMMENTS option of the index-configuration-options parameter of the SYSPROC.SYSTS_CREATE stored procedure. |
TABLEMBR | VARCHAR(10) | Yes | The table member over which the text index is built. Used to track the specific member being indexed if the file is a multi-member file. If the value is null, the member is the first and only member of the table. |