Kbase P16962: How can the agents re-establish connections to a database wh
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/17/2003 |
|
Status: Verified
GOAL:
How can the agents re-establish connections to a database which resides behind a NAT firewall?
GOAL:
Configuration involves CISCO routers with network translations tables
FIX:
There are two ways to address this issue.
The best solution is to set the WebSpeed agents to connect & disconnect to
the database "on the fly". Change the web-disp.p or use the environment variables to make WebSpeed connect and disconnect "on the fly". You can give your end-users a nice "The database is currently unavailable" message, rather than "crashing" with a yellow screen.
An alternative solution is to (connect the agent to the database setting the connection settings within the srvstartup) set the minSrvrInstance to zero and the autoTrimTimeout (for the agent) to a value before the router's mapped tables are cleared.
Example settings
Routers mapped tables are cleared = every 1 hour
autoTrimTimeout is set = 10 minutes
minSrvrInstance set = 0
This way, if there is no agent activity for 10 minutes, the broker will trim the agents down to zero. Hence, the router's mapped tables are cleared every hour, thus when a new request comes in, the new agent will be fired off and be able to located the database.