Outside running OS Kill signals to terminate the PID of the client, which can lead to dbdowns, or application code using the DISCONNECT <ldbname> statement to disconnect the current client session, PROSHUT or PROMON are the only tools available to disconnect a client from a database.
To disconnect a User from the database with PROMON or PROSHUT:
- promon dbname > Options: 8. Shut Down Database > 1 Disconnect a User
- proshut dbname > Option: 1. Disconnect a User
- proshut dbname -list > Option: 1. Disconnect a User
- proshut dbname -C disconnect <user number>
For further information refer to Articles:
A client can only be disconnected with a user who started the database or the user themselves to perform the disconnect. Refer to Article
Since OpenEdge 11.5 other PROMON sessions can also be disconnected:
When there are too many user connections to manually disconnect every connected user, or users need to be disconnected from a remote client session to where the database is running, the process can be scripted by interrogating the
_Connect VST and parsing the
_Connect-Usr to an OS-COMMAND which runs the PROSHUT -C DISCONNECT utility. Refer to Articles:
Considerations when needing to terminate a client session by disconnecting it:
