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?