Text Search Index view
When a text search index is created with SYSTS_CREATE, a view representing the index will be created. Querying the text search index’s view can help the user obtain the status of the index. The text search index view’s name is same name as the text search index’s name that was specified while creating the index with SYSTS_CREATE.
The following table shows the content of text search index’s view.
Column name | Data type | CCSID | Nullable? | Description |
---|---|---|---|---|
TABLESCHEMA | VARCHAR(128) | 1208 | No | Schema name of the base table. |
TABLENAME | VARCHAR(128) | 1208 | No | Unqualified name of the base table. |
COLUMNNAME | VARCHAR(128) | 1208 | No | Unqualified name of the text column from the base table. |
SERVERID | INTEGER | No | Unique server ID from SYSTEXTSERVERS. | |
SERVERNAME | VARCHAR(128) | 1208 | No | Unqualified name of the text search server. |
SERVERSTATUS | VARCHAR(32) | 1208 | No |
|
STAGINGTABLENAME | VARCHAR(128) | 1208 | No | Unqualified name of the log table for the text search index. |
LASTUPDATETIME | TIMESTAMP | Yes | The time that the text search index was last updated. | |
LASTUPDATESTATUS | VARCHAR(30) | 1208 | Yes |
|
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) | 1208 | No | The update frequency for the text search index as specified by the SYSPROC.SYSTS_CREATE stored procedure. |
PENDINGCOUNT | INTEGER | No | Indicate how many rows to be indexed in next update process. | |