Kbase P120130: When to use prostrct repair command against a database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/4/2008 |
|
Status: Unverified
GOAL:
When to run prostrct repair command against a database
GOAL:
How to use prostrct repair
GOAL:
How to update the location for a database that was copied or moved from one directory to another using an Operating System command
FIX:
The structure description file (.st) is the text-file representation of the database structure that is saved in the .db file. The .db file, or database control area, acts as a table of contents for the database engine, listing the name and location of every area and extent in the database. The database structure is written into the .db file for the database, and when a database is moved using operating system utilities, the .db file must be updated accordingly.
The .db file is updated via the the st file and running prostrct repair. Prostrct repair should be run when a database is moved to a new file system or location so that the directory structure is changed, e.g. when a database is copied from drive c:\Progress to drive d:\Progress using os utilities.
Steps to follow:
1. Edit the database structure file to reflect the new paths to the database files.
2. Run prostrct repair dbname using the edited .st file to change the structure file to show the new paths:
prostrct repair sports sports.st
If the st file is located in the same directory as the .db, then the st file doesn't need to be specified in the prostrct repair command.
3. Run prostrct list. This utility checks in the .db and writes the locations it finds there in to the st file. This can be used to check that the new locations recorded in the .db are in fact correct.