Kbase P106016: What is the predefined WebSpeed environmental variable DB_FAILOVER
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/12/2005 |
|
Status: Unverified
GOAL:
What is the predefined WebSpeed environmental variable DB_FAILOVER
GOAL:
How to define DB_FAILOVER to the WebSpeed Broker and it's agents
FACT(s) (Environment):
WebSpeed 3.1D
WebSpeed 3.1E
OpenEdge 10.x
FIX:
When up time matters then redundancy is the law. If the reconnect logic fails the agent may set a ?failover? condition and make sure all agent switch to a backup database set. The ?failover? mode can also be set manually for maintenance situations. A ?DB_FAILOVER? program may be specified to pick up the ?failover? event and run programs to perform a system reset or maybe contact administrators. This environment variable sets backup databases for the primary databases defined in the environmental variable DATABASES. WebSpeed agents will switch to backup database (and to System Failover mode) after a failure to connect to any of the primary databases. Once agents have been switched to the backup database, they will not automatically test to see if the original database is back up.
The value to be entered would be the logical database name = [connection parameters | program name] For example:
db1=-pf c:/databases/db1.pf | sports2000-sportstartup.p
Activation of this variable can be accomplished either by:
1. Using the Progress Explorer and entering the name of the variable in the NAME field in the brokers' Environment Variable Properties dialog box and the Value in the VALUE field.
2. Manually add to the ubrokers.property file under the Environment section for your broker.
[Environment.wsbroker1]
DB_FAILOVER=<logical database name = [connection parameters | program name]>