Kbase P7433: How to change the location of database extents
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/8/2011 |
|
Status: Verified
GOAL:
How to change the location of database extents
GOAL:
What needs to be done if I move my database to another disk
GOAL:
Can the bi file be moved to a different disk?
GOAL:
How to change the location of the bi file
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:
For Progress 8.x using single volume databases, use -g parameter with the "proserve" command to specify where the bi file is to be located.
If using this parameter, all utilities must also specify the -g as well.
The -g may also be used for Progress 8.x multi-volume databases, but it is not recommended. Instead, use the structure description file to relocate the bi file.
The -g parameter was discontinued in version 9.x and later.
For Progress 9 or late where all databases are multivolume databases, extent(s) can be moved to another volume or disk by running PROSTRCT REPAIR option after modifying the structure description file (.st).
Do not try this method when the database is in a crashed state or it will result in a date mismatch for the files.
Follow these steps:
1. Stop the database and Make a complete back up.
2. Make a backup of your current .st file
3. run PROSTRCT LIST to update the current .st file
eg: prostrct list <database name>
4 . Use OS utility to move the files to the new location
3. Change the structure file (.st) to reflect the extents new location.
4. Run prostrct repair with the modified st file.
eg: prostrct list <database name> [<new.st file>]