Kbase P96459: How to manually clear pending database connections?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/3/2010 |
|
Status: Verified
GOAL:
How to manually clear pending database connections?
GOAL:
How to use promon to clear pending database connections?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
The promon R&D, Option 1 Status Displays, 3 Servers menu shows servers with pending connections that have not been cleared. Pending connections occur when a network glitch happens or a user disconnects from the database before the broker handed the connection to the Server.
To manually clear the pending database connections perform 1 of the following 2 procedures:
1. Use a restricted promon screen to clear the connections. In order for this screen to clear the pending connections the database must have been started with the -pennConnTime parameter.
From promon perform the following:
promon dbname:
R&D
4. Administrative Functions
6. Restricted Options
Enter resticted option key: (0 to 99999): 32784
This option is used to clear ALL current pending connections regardless of the -PendConnTimeout startup option. If existing servers are still accepting client connections, the possibility exists that valid in flight connections will not complete as expected.
2. If PennConnTime is not enabled a connection can be established directly to the server's port with the pending connection. On the disconnect of the client the pending connection will be cleared. The additional connection directly to the servers port will free the pending connection because the server is waiting for a connection.
To do this perform the following:
From promon dbname, 1 Status 3, Servers, obtain the port number of the server with a pending client connection
Sv Pend. Cur. Max. Port
No Pid Type Protocol Logins Users Users Users Num
0 1928 Login TCP 1 0 0 5 3500
1 11943 Auto TCP 1 0 1 5 1028
2 0 Inactive 0 0 0 0 0
Determine the port number of the server that has the pending connection by using the port num column of the server with .the pending connection(s). In the above example the port number of the server process is 1028. For this example assume sv No 1 has a pending connection.
Connect a client directly to the servers port number.
Example: mpro dbname -S 1028
The connection will establish a client connection directly to the server, to confirm refresh the promon server screen.
The output should be similar to:
Sv Pend. Cur. Max. Port
No Pid Type Protocol Logins Users Users Users Num
0 1928 Login TCP 1 0 0 5 3500
1 11943 Auto TCP 2 0 2 5 1028
2 0 Inactive 0 0 0 0 0.