Kbase P39432: How to terminate a remote server process?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/01/2011 |
|
Status: Verified
GOAL:
How to terminate a remote server process?
GOAL:
How to terminate an ABL server using promon
GOAL:
How to terminate a _sqlsrv2 process?
GOAL:
How to trim ABL and SQL remote server processes
GOAL:
Is it possible to trim _mprosrv and _sqlsrv2 processes?
GOAL:
How to terminate a SQL server _sqlsrv2 process from the database
GOAL:
Is it possible to auto trim _sqlsrv2 processes?
GOAL:
Can I disconnect an SQL server in Promon?
GOAL:
How do I disconnect an SQL server?
GOAL:
Can i auto trim SQL servers?
GOAL:
Can I set a SQL server to timeout if no one is using it?
GOAL:
Why won't SQL remote servers terminate through promon ?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
Progress 9.1E
OpenEdge Category: Database
CAUSE:
Bug# OE00136011
FIX:
Database remote servers can neither be trimmed our timed-out like ubrokers. However, since Progress 9.1E or later, a _mprosrv (ABL remote server process) can be terminated using promon and in OpenEdge 10.1C, the capability to terminate SQL servers was added to promon.
After determining which remote server(s) need to be terminated use the following steps, but please read the cautionary notes below.
STEPS:
1) Enter the Progress Monitor utility by running:
$ promon <dbname>
2) At the menu, enter R&D (note that this is a hidden option in earlier versions and does not appear within the standard menu)
3) Select option #4: Administrative Functions
4) Select option #7: Terminate a Server
Sv Pend. Cur. Max. Port
No Pid Type Protocol Logins Users Users Users Num
0 3992 Login TCP 0 0 0 5 6699
1 3452 Auto TCP 2 0 0 5 3000
5) Enter the Server number (first column number) associated with the remote server to be terminated. The PID of the process is another useful piece of information which can assist correlating the correct server number to be terminated.
After terminating the server the Administrative Functions menu screen will appear. At this stage either repeat the above steps for remaining remote servers, or Select "X" to end the promon session.
Note:
1. Login Brokers (primary or secondary) cannot be terminated with this functionality (ie the -S that the client/server connection connects TO as opposed to the remote server the client communicates WITH once connection is established which can be terminated with this promon utility).
2. The promon "option #7: Terminate a Server" has been available since Progress 9.1E but only applies to ABL remote servers (_mprosrv) can be terminated ie: remote SQL servers (_sqlsrv2) cannot be terminated prior to OpenEdge 10.1C.
For versions prior to OpenEdge 10.1C a third party tool, such as kill on UNIX or tskill.exe on Windows, can be used to kill the SQL servers. However it is not recommended and if exercised, ensure that all users connected to that remote SQL server have been disconnected beforehand. If using a kill command on UNIX, you may want to make use of a kill -15 PID (Process Id) of the server process. A kill -1 is ignored by the Server process. See solution: P67938, "How Progress interprets and handles kill Signals"
3. Caution should be exercised when terminating a remote server to ensure that there are no users currently connected to the process being terminated.