Kbase P48144: How to use proshut to disconnect a user from command line instead of the proshut menu?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/04/2009 |
|
Status: Verified
GOAL:
How to use proshut to disconnect a user without using option 1 of the proshut menu
GOAL:
How to disconnect a user using proshut from the command line.
GOAL:
How to disconnect a user from the command line?
GOAL:
How to shut down a user connection from the command line?
GOAL:
What does proshut -C disconnect do?
GOAL:
How to disconnect a user from a database without using promon.
FIX:
The proshut command has an option called disconnect which allows a DBA to disconnect a client by making use of the user number from command line.
Command Syntax: proshut dbname -C disconnect <usernum>
Example: proshut dbname -C disconnect 22
The proshut command with the disconnect option performs the same function as option 1 of the Proshut Menu. The command when followed by a user number, initiates a disconnect of the user / client from the database. The proshut command however when issued in this manner does not provide a listing of users connected to the database. Rather the proshut command with the disconnect option is expecting the person issuing the command to identify the user number to be disconnected. The user number can be obtained via the database log file (dbname.lg). The user number can also be obtained programmatically via the VSTs (Virtual System Tables) by making use of the _Connect table.