Kbase P13885: How are the _sqlsrv2 processes started and stopped?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/12/2009 |
|
Status: Verified
GOAL:
How are the _sqlsrv2 processes started and stopped?
GOAL:
What spawns an _sqlsrv2 process?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
A _sqlsrv2 process is spawned by the database broker so that an SQL92 client can connect to the database. SQL clients include SQL Explorer, JDBC driver, ODBC driver, etc.
The _sqlsrv2 processes are suppressed when the database broker is shutdown; the SQL92 clients' connection to the database are closed at that time.
There is no way to gracefully shutdown the _sqlsrv2 process without shutting down the database. Killing the process may cause the database to shutdown.