General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Index File corruption
Hi all,
I've an accounting app running on a Novell network running on both TCP/IP and IPX/SPX protocol via Win 98 terminals.
The problem is that index files get corrupted practically every day. Every time reindexing fixes the problem. How the index corruption manifest itself is that some records go missing when searched.
I've tuned the Novell setting as suggested by other members on the forum (disabling write behind cache, enabling extended file locks etc) but the problem does not go away.
Is there a methodology or software tools that I could use to narrow down and identify the cause of the problems?
The tables involve have 4 tags one for the surrogate key, document number, date and deleted().
What is funny is that every time when the index is corrupted, some records go missing. I've used browse to look at the table and found a strange behaviour for the missing records. With set deleted off, I could see those records and the delete mark is not there but with set deleted on, I could not see the records at all!
Any help on this would be very much appreciated.
Yau
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only