Hi!

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?

Please help!

Camillo

I think this is a known issue.

1) Anybody has suggestions?

Doesn't it help if you fragment your index?

2) Where can I look for Verity error messages? (In the standard Informix logs I cant find any error!!!)

No Idea
3) Could be a problem of wrong sbspaces space or configuration parameters?

No it is not. This is a known issue with Verity. I even think there is a patch for it available, but support can't deliver it since this product is end of life.

4) Does Informix knows when an index gets corrupted?

It knows when it has to search it, yes.

5) When Informix automatically updates its indexes?
Everytime a record is inserted or updated or deleted.