Kbase P6195: How to disconnect an inactive user from a Progress database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/12/2008 |
|
Status: Verified
GOAL:
How to disconnect an inactive user from a Progress database
GOAL:
How to disconnect any user from a Progress database
GOAL:
How to gracefully disconnect a user from the database
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Versions
FIX:
Progress offers some utilities to help on the process of disconnect users from the database automatically. The utilities are:
proshut <db-name> -C list
List all users connected to the database
proshut <db-name> -C disconnect <user-num>
Disconnect a specific user from the database, the user number needs to be provided during the execution of the command.
Using these two commands along with information from the virtual system tables (VST?s) the system administrator can build a 4GL procedure to disconnect a user from the database that suits the need of the application.