Unanswered: Datablade Verity FullTextSearch Index Corruption
I have a big problem.
I have a table with approximately 160.000 records and 1 Verity VTS Index on a CLOB data type.
This table is very important!
It is updated all day like 500 times and has huge updates in few minutes.
It is reindexed automatically every night when nobody uses it.
The PROBLEM is:
Randomically the Index becomes corrupted (I guess so!) and every SELECT in the CLOB field gives a 0 records result; the solution is to rebuild the Verity Index (which takes 20 minutes or so) with the SQL command "DROP INDEX index_name; CREATE INDEX index_name ON table_name (field_name VTS_CLOB_OPS) USING VTS IN space_name".
The QUESTION is:
1) Anybody has suggestions?
2) Where can I look for Verity error messages? (In the standard Informix logs I cant find any error!!!)
3) Could be a problem of wrong sbspaces space or configuration parameters?
4) Does Informix knows when an index gets corrupted?
5) When Informix automatically updates its indexes?