The problems that you have experienced indicate that there are several weaknesses in your environment:

1. The frequency with which DBO/VERIFY was being executed.

2. The backup and retention cycle for your database files.

3. Lack of adequate controls over access to and retention of your RUJ files.

However, all of that is outside of the scope of your immediate problem, which is fixing your database. The DBO/VERIFY utility indicates that your database contains corruption of several index nodes. While we can theoretically patch the database using the DBO/ALTER (DBMS low-level patching utility), the extent of the corruption will make this a slow and error-prone task.

To solve this problem, we used a combination of tools that allowed us to automate much of our work.

1. We wrote a special purpose program to obtain the pointer clusters from the current records, and store them in a RMS file.

2. Using a special version of SCI's DBInitialize program, we were able to remove the pointer clusters and index nodes of the affected set types.

3. We wrote a special purpose program that read the pointer information contained in step 1 to reconnect the pointer clusters of the appropriate sets.