Kbase P16704: How to rename a Progress 9.x Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/23/2007 |
|
Status: Verified
GOAL:
How to rename a Progress 9.x Database
FACT(s) (Environment):
Progress 9.x
FIX:
In order to rename a Progress DB an its extents you have to do the following steps:
1.- Stop the database and make a backup of your DB files.
2.- Edit the database .st file. Replace the old DB name with the new one. Be sure to keep the file conventions. For example, if you have a database named Sports and you want to rename it as Foo, you need to make the following changes:
#
b /users/xyz/foo.b1
#
d "Schema Area":6,32 /users/xyz/foo.d1
#
d "Info Area":7,32 /users/xyz/foo_7.d1
#
d "Order Area":8,32 /users/xyz/foo_8.d1
Notice that "_7" and "_8" denote the area where the extents belong to.
3.- Rename the .db file and all the existing extents from Sports to Foo as they appear in the new .st file.
4.- Type:
Prostrct repair foo foo.st
This will update the extents references. The database is now renamed as Foo.