How to rebuild your RM and Free Chain?
This kbase is being generated to provide you instructions on how to
manually rebuild your RM and Free Chain within Progress.
The RM and Free chain are kept in sync by the database engine. There
are times when doing a proutil command with the dbanalys and tabanalys
options that you may receive warning messages. These warning messages
are:
RM chain count inconsistancy. (3902)
The master block indicates <num> RM chain blocks. (3903)
The actual number of RM blocks = (3904)
RM block found not on RM chain, but flagged RM chain. (3914)
In the event of receiving these warnings, you may elect to manually
rebuild your RM and Free Chain. You can do this by following the
steps listed below.
Note: It is recommended that you take a backup of your database
prior to doing any repair or rebuild activity on your database.
1. Shutdown your database (i.e. proshut)
2. Truncate your bi file (i.e. proutil dbname -C truncate bi)
3. Backup your database (i.e. probkup or unix utilities like tar)
4. Then you will need to enter a non-documented, non-supported tool
called dbrpr. This tool is an option to the proutil command.
The syntax for this command is:
proutil dbname -C dbrpr
Note: Menus displayed in this kbase entry are for version 7 of
Progress. If you are running verion 6, they may appear
slightly different, but do contain similar options to the
ones represented here.
DATABASE REPAIR MENU
--------------------
1. Database Scan Menu
2. Test One or More Indicies
3. Remove Bad Record Fragment
4. Dump Block
5. Load Block
6. Copy Bytes Between Files
7. Load RM Dump File
8. Reformat Block to a Free Block
Q. Quit
Choice:
5. Select option 1 to enter the Database Scan Menu. The menu
below will appear on your screen.
DATABASE SCAN MENU
------------------
1. Report Bad Blocks
2. Repair Block Alignment
3. Reformat Bad Blocks
4. Report Bad Records
5. Delete Bad Records
6. Dump Records to RM File
7. Rebuild Free Chain
8. Rebuild RM Chain
G. GO
Choice:
6. You will want to select options 7 and 8 from this menu. This menu
is a toggle menu. In other words, you would enter 7 and <press
return> and then 8 <press return>. As menu items are selected in
this manner you will see an ON statement appear on the left hand
side of the menu option you selected. Then type G for GO.
7. You will now recieve the following prompt:
Scan Backward (Yes/No)?
Answer yes and press return.
When this completes, it will return you to the Main Database
Repair Menu. Type Q to quit dbrpr. Your RM and Free chain
have now been succesfully rebuilt.
Progress Software Technical Support Note # 16753