Kbase P180778: One method to restructure a database so that the data area has multiple smaller extents rather than
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/18/2011 |
|
Status: Unverified
GOAL:
One method to restructure a database so that the data area has multiple smaller extents rather than one large extent
GOAL:
How to create a new structure for a database using probkup and prorest
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
Prior to following the steps below, run prostrct list dbname new.st to make sure you are looking at the current database structure.
1. Modify the structure file created on running the list command (new.st) with the desired data extents in the area of concern using the original st file as a guide.
2. Run probkup dbname dbname.bak and then verify the backup file.
3. Make an OS copy of all the database files if space is available.
4. Run prodel of the database:prodel dbname and answer yes to remove files
5. Delete dbname.st file
6. Copy new st file into the correct database directory and rename to dbname.st
7. Run prorest dbname dbname.bak