Kbase P67530: How to run prostrct repair for a version 8 multi-volume database within a version 9.1D install.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/01/2009 |
|
Status: Verified
GOAL:
How to run prostrct repair for a version 8 multi-volume database within a version 9.1D install.
FACT(s) (Environment):
Progress 9.1D
Windows 2003
FIX:
The prostrct repair utility can be accomplished on a multi-volume version 8 database, within a version 9 install, by pointing to the version 8 utilities that are installed by version 9.
Backup the database before continuing.
The utilities are located in %DLC%\bin\82dbutils or %DLC%\bin\83dbutils.
Use the 83dbutils if version 8 is >8.2, if not, use the 82dbutils.
Change to the directory where the database is located:
1. Set up the environment to point to the desired dbutils directory for the session.
2. Set the DLC, PROMSGS, PROCONV variables to point to the files in the correct dbutils directory:
Set DLC=<install directory>\bin\83dbutils,
Set PROMSGS=<install directory>\bin\83dbutils\promsgs,
Set PROCONV=<install directory>\bin\83dbutils\convmap.cp.
3. Temporarily alter the startup.pf to reflect version 8 startup.pf or use the PROSTARTUP variable to point to a modified startup file.
4. Rename the current .st file
5. Modify the current structure file to the current paths for the extents
6. Modify the fixed size of an extent to a value that is divided evenly by (16*blocksize) rounded up from the current setting, i.e.,500000/(16*1024)=30.5175....31*(16*1024)=507964
7. Run 83_dbutil prostrct repair <dbname.st>.
8. Rename the current .st file.
9. Run 83_dbutil prostrct list dbname.