Kbase P20918: How to shut down a database remotely
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
GOAL:
How to shut down a database remotely
GOAL:
How to prevent remote shutdown of a database
FACT(s) (Environment):
Progress/OpenEdge Versions
FIX:
The proshut command can be used in order to shut down a database remotely.
Please be aware that the database server must be started with the -S option for this to work. The following example assumes that the database server is on a machine named dbserv.
On the server machine:
proserve sports2000 -S 6789
On the client machine:
proshut sports2000 -H dbserv -S 6789
This will show the list of users currently connected (if any), and then following menu:
1 Disconnect a User
2 Unconditional Shutdown
x Exit
Enter choice> _
Choosing option 2 will shut down the database.
Please be aware that after you choose option 2, you will see informational message 1613 and then you will be immediately returned to the operating system prompt:
1 Disconnect a User
2 Unconditional Shutdown
x Exit
Enter choice> 2
Shutdown is executing. (1613)
proenv> _
You will not see informational message 1614 (Shutdown complete).
Also, please be aware that it may take some time before the database is actually down, because of the clean up operations that the database server has to perform before actually bringing the database to a halt.
To prevent remote sessions from shutting the database down, the following database startup parameter needs to be specified: -normtshudown. This feature is available since Progress 9.1E01 and OpenEdge 10.0B02 +