Consultor Eletrônico



Kbase P4898: How to disconnect any user from a Progress database.
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   11/21/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

GOAL:

Who can disconnect a user using the Proshut menu?

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 (Windows) or root (UNIX) can build a 4GL procedure to disconnect a user from the database that suits the need of the application.