Kbase P116833: How to change the directory location of existing database files?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/03/2009 |
|
Status: Verified
GOAL:
How to change the directory location of existing database files?
GOAL:
How to fix the database after moving existing database extents?
GOAL:
How to move existing database areas to a new location?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
You must first move the files and then change the pointers within the database to point to the new location of the files:
1. If you don't already have a database structure file for this database, you must first create one before moving the database:
prostrct list <dbname>
NOTE: Even if you already have a database structure file, it is HIGHLY recommended that you create a new one. The reasons for doing this are:
a) The existing one could be out of date and not contain all database files.
b) If any fixed length extent values are not EXACTLY correct, you will need to manually calculate what they need to be before prostrct repair will run. Note that prostrct repair will NOT automatically recalculate these values like prostrct create does. i.e. Prostrct create adjusts the values and makes them divisible by 8.
2. Move the database files to the new directory location, including the database structure file that you just created <dbname.st>.
3. Modify the database structure file <dbname.st> and change the location of all database files that have been moved.
4. Run prostrct repair to apply the new file locations to the database:
prostrct repair <dbname> <dbname.st>