Kbase P136549: How to move DB extents from one directory into another
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/03/2009 |
|
Status: Verified
GOAL:
How to move DB extents from one directory into another
GOAL:
What to do when a DB is moved to a different directory.
FACT(s) (Environment):
All Supported Operating Systems
Progress 6.x
Progress 7.x
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
The structure file paths are stored in the DB, to move all or some of the extents to a different directory you need to change these paths to point to the new directory. In order to do this perform the following steps:
1) Open the .st file and update the directories for the extents.
2) Run the following command to update the structure information:
prostrct repair <db-name> <new-st-file>
Example:
Lets say that your DB extents are located in the directory /disk1/sales/
Your .st file would look like:
#
b /disk1/sales/sports.b1
#
d "Schema Area":6,32 /disk1/sales/sports.d1
#
d "Info Area":7,32 /disk1/sales/sports_7.d1
#
d "Order Area":8,32 /disk1/sales/sports_8.d1
When an extent is moved to a directory named /disk2/sales, it is necessary to modify the .st file to reflect the change:
#
b /disk1/sales/sports.b1
#
d "Schema Area":6,32 /disk1/sales/sports.d1
#
d "Info Area":7,32 /disk1/sales/sports_7.d1
#
d "Order Area":8,32 /disk2/sales/sports_8.d1
Then run the command:
prostrct repair sports sports.st
Once this is done the DB can be accessed.