Detailed index status

You can get a more detailed overview of the status of a specific index in the Settings... form which is opened from the Text Indexes form.

On the WorkZone Content Server, press Start and type ScanSQL to open the ScanSQL form. You can also press ALT+R in windows to open the Run window and type ScanSQL.
In the ScanSQL form, click SjBase > Text Indexes to open the Text Indexes form.
In the Indexes field group, select the index you want to see a detailed status for and click the Settings for.... button to open the settings form for the index. You can also double-click the index you want to see a detailed status for to open the Setting for... form.
In the upper part of the settings form, a more detailed status table is displayed for the index.

The status includes the following fields:

Field	Description
Status	Displays a status code for the entire index.
Domidx_stat	The value is retrieved from the DOMIDX_STATUS column in the ALL_INDEXES view and displays a final status of the domain index. Status codes for Domidx_stat: NULL - Index is not a domain index VALID - Index is a valid domain index IDXTYP_INVLD - Index type of the domain index is invalid
Domidx_ops	The value is retrieved from the DOMIDX_OPSTATUS column in the ALL_INDEXES view and displays the current status of the domain index. Status codes for Domidx_ops: NULL - Index is not a domain index INPROG - The index creation is in progress VALID - Operation performed without errors FAILED - Operation failed with an error
Ddl_status	Defines the optimization status of the selected index. The field value Optimized indicates that the index has been automatically optimized by the system and is ready for use.
Pending	Displays the number of records queued for synchronization with the domain index.
Errors	Displays the number of errors currently registered for the selected index.
Last_Error	Displays the date and time of the last registered error in the index.