Kbase 21479: What To Do Before Dumping Data After You Used the Option -F?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/01/2006 |
|
Status: Unverified
SYMPTOM(s):
Error message when starting database
Database was previously forced into using the the -F option.
** Your database was damaged. Dump its data and reload it. (37)
What To Do Before Dumping Data After You Used the Option -F?
CAUSE:
When forcing into a database with the -F option, the above message will appear everytime you start your database. This message is a reminder that the action needs to be taken.
FIX:
Progress recommends that you perform a dump / load of your database to guarantee integrity. While dumping data, to make sure you get all the records from your tables, you must be sure that you are using a valid index. An IDXBUILD or IDXFIX of the primary index on the tables prior to dumping is recommended after having ignored the Database modifications written within the Before Image file (using "proutil truncate bi -F").
NOTE: Please do take a backup of your database prior to running idxbuild.
Please refer to Progress Solution P24330 for further details on the consequences of using -F.
FIX:
?References to Written Documentation:
Progress Solutions:
P24330, "Consequences of using the ?F startup option"
2073, "How to Correct Corrupt Data and Their Causes"
19162, "Dumping a Table While Having a Damaged Primary Index"