When the index status of a table or column shows Search not available or Update not available, an error has occurred during indexing that prevents you working with the index.
This command resets the index status so that you can continue to work with it. Before resetting the index status, check for any errors that may be logged in the index's log table (see Displaying error events).
Authorization
None.
Command syntax
>>-RESET INDEX STATUS--table-name-------------------------------> >-----+-----------------------------+-------------------------->< '-HANDLE--handle-column-name--'
Command parameters
Usage notes
For a multi-index table, you must specify a handle column name.
For a common-index table, each enabled column in this table is reset.