Kbase P6447: How to move the location of an extent in a multi-volume database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
GOAL:
How to move the location of an extent in a multi-volume database.
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
Prior to beginning this operation, the database must be shutdown. Progress also recommends that you backup your database using probkup.
1) Run "prostrct list dbname" (to be sure your working with the correct
copy of the database structure file)
2) Move the DB extent(s) to their new physical location using the appropriate
operating system copy command.
3) Modify the database structure (.st) file to indicate the database extent(s)
new physical location.
4) Run prostrct repair dbname dbname.st
5) Run prostrct list dbname test.st (to be sure the prostrct repair worked
properly (prior to starting the database).
The test.st file should be used to compare the .db files contents in relation to the physical layout of the database's contents. Once this had been confirmed, the test.st file can be discarded.