Kbase P23240: Where does the schema get moved to by the MVSCH command?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/08/2008 |
|
Status: Verified
GOAL:
Where does the schema get moved to by the MVSCH command?
GOAL:
What is the proutil mvsch (Move Schema) command?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1C
Progress 9.1D
Progress 9.1E
OpenEdge 10.x
FIX:
The schema gets moved to the next unused Data Area.
Data areas begin with Area 7.
The database should be backed up prior to issuing the move schema command because the command is irreversible and if any errors occur that would prevent its complettion the database may be left in an unusable state.
The BI should be truncated.
proutil <dbname> -C truncate bi
The command which initiates the move schema operation is:
proutil <dbname> -C mvsch
The current schema area will be renamed to "Old Default Area".
A new area will be created named "Schema Area".
All the schema data will be moved to the "Schema Area".