How can I stop a single Progress OpenEdge server process and not the whole database?
0
votes
2
answers
1594
views
Is there a way to stop a single
_mprosrv
process started by the database broker? All I can find from documentation and google searches are ways to disconnect a single user connection or shut down the entire database.
For context, the problem is, that we are running an OpenEdge 10.2 database, that is mostly used by remote 4GL clients and one singular client using SQL over ODBC to run data export queries once a week. After rebooting the entire server in our current configuration, the database started up and broker spawned _mprosrv
server processes up to the maximum number of servers allowed for the broker. Therefore it can't start up a _sqlsrv2
process any more, because all the slots are occupied. Even during low usage periods where no remote 4GL clients are connected, the ODBC connection does not succeed, since the idle servers are not shut down to allow new servers to be spawned.
Hence the question - can I shut down a single 4GL server process to trigger a new server creation for SQL connections without taking the entire database and application offline?
Asked by Tarmo R
(111 rep)
Nov 18, 2018, 11:55 AM
Last activity: May 19, 2020, 07:53 AM
Last activity: May 19, 2020, 07:53 AM