When to Remove an Index Manually [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== When to Remove an Index Manually ======

Manually removing an index may be required when corruption or data loss occurs to the index portion of your data file (the so-called "bang file", called that because the filename is prefixed with an exclamation point (!). If this error occurs frequently, make sure that the Windows 2000 Service is installed and running on your system.  The Windows 2000 Service is designed specifically to reduce the possibility of these types of problems.

In this example we will completely remove all indexes from the CUSTOMERS table in the EXAMPLES application.  The data for the EXAMPLES application is found in the DATAVOL volume (a subfolder of C:\RevSoft\OI32Bit, the folder in which the OpenInsight executables are stored).  Do the following:
 
Before removing indexes manually, you need to remove SI.MFS, the MFS that controls index updates, from the CUSTOMERS table.  Do the following:
 
- Log into your SYSPROG application.

- From the System Editor's command line, enter the following,
 
Run ATTACH_TABLE 'DATAVOL','REVMEDIA'
 

  - Select File-Open Record from the main menu.
  - Enter REVMEDIA as the Table name.
  - Enter CUSTOMERS*EXAMPLES as the Row name.
  - Remove the entry for SI.MFS in the second field of the record.
  - Save the record.
  - Exit the System Editor.


You may now begin the process of removing indexes manually, as described in the topics that follow.