Kbase P125614: How to disable or remove a target database in a multiple target replication database configuration.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/03/2008 |
|
Status: Verified
GOAL:
How to disable a second target database in a multiple target replication database configuration.
GOAL:
How to remove a second target database in a multiple target replication database configuration.
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Versions
FIX:
The create a second target database without stopping the source database follow the steps below:
You can do the following on 9.1E and newer:
1. dsrutil -db <db-name-source> -C terminate server
2. Edit source.repl.properties files and remove references to second db-agent (the one you want to remove).
3. dsrutil -db <db-name-source> -C restart server
source and target will resync.
For 9.1D:
1. Stop databases
2. Edit source.repl.properties files and remove references to second db-agent
3. Start databases and source and target will resync.
example of the Source.Repl.Properties file:
To reference to agent1 and not replicate the target database remove "agent1," from the "control-agents" line.
[server]
control-agents=agent1, agent2
database=source
transition=manual
transition-timeout=600
[control-agent.agent1]
name=agent1
database=target
host=localhost
port=4501
connect-timeout=120
replication-method=async
critical=0
[control-agent.agent2]
name=agent2
database=target2
host=localhost
port=4502
connect-timeout=120
replication-method=async
critical=0
[transition]
database-role=normal
-----------------------
Change would like as follows:
[server]
control-agents=agent2
database=source
transition=manual