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.

Table 1. Contents of the view created by SYSTS_CREATE
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
  • ‘STARTED’ – Server is running.
  • ‘STOPPED’ – Server is stopped.
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
  • ’NEVER UPDATED’ – The index was not updated before.
  • ‘UP TO DATE’ – Last update succeed and there is no pending changes to do.
  • ‘CHANGES PENDING’ – Last update succeed, but there are still new changes to be updated.
  • ‘FAILED’ – Last update failed.
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.