Kbase P20725: Does the database have to be shut down to do schema changes?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/06/2003 |
|
Status: Unverified
GOAL:
Does the database have to be shut down to do schema changes?
FACT(s) (Environment):
Progress 9.x
FIX:
When making schema changes of any kind, the database should be connected in single-user mode with the Data Administration (Windows) or Data Dictionary (Unix) utilities. Such changes should not be carried out if the database is running in multi-user mode.
The reason behind this is that if a user is connected to the database, that user might be carrying out some activity that would require a schema lock, thus the update of the schema getting done by the administrator would be blocked.
It is also administratively easier, connecting in single-user in order to make the schema changes.