Kbase P30876: How to change Storage Area names?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/16/2009 |
|
Status: Verified
GOAL:
How to change Storage Area names?
GOAL:
Can Storage Areas names be changed after creation ?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.X
All Supported Operating Systems
OpenEdge Category: Database
FIX:
STEPS:
1.) Stop all processes running against the database (don't forget cron jobs) and take a full verified backup of the database.
2.) Run "prostrct list" to get the latest structure of the database.
$ prostrct list dbname dbname.st
3.) Edit the .st file created in step 2 to reflect the new Storage Area name(s).
Please note that "Schema Area" 6 is reserved and must not be re-named.
4.) Delete (or preferably re-name) the Database Control Area (the dbname.db file).
5.) Run: $ prostrct builddb dbname dbname.st
Where "dbname.st" is the edited structure file from step 3.
6.) Backup the 'New_Storage_Area_named' database.
Please note that if after-imaging is in use, the builddb utility will disable the after-imaging flag in the master block i.e. in dbname.d1. As a consequence, the existing ai files will have to be backed up for reference for the pre Area-Name's change baseline, re-added (if not included in the dbname.st used in step 5 above) and aimage begin for the new hotspare baseline which then needs to be re-instated. Please refer Progress Solution P30870