Kbase P132787: Why is the _sqlsrv2 process still active even though users have logged off the database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/28/2009 |
|
Status: Verified
GOAL:
Why is the _sqlsrv2 process still active even though users have logged of the database?
GOAL:
Why doesn't the _sqlsrv2 process terminate when a user logs out of the database?
GOAL:
How come the _sqlsrv2 process does not go away when a user logs out?
GOAL:
The ODBC user is no longer connected to the database, but there is this _sqlsrv2 process hanging around. Why?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
Progress 9.1D
Progress 9.1E
FIX:
The _sqlsrv2 process is a server process that is spawned by the database broker when an ODBC or JDBC user connects to the database. This process is multi-threaded and can support many users. The process will remain active on the machine to handle request from other ODBC or JDBC clients. The _sqlsrv2 process will terminate or cease to exist on the machine, when the database is shutdown.