Consultor Eletrônico



Kbase P108914: How to create a Replication target database for an existing database.
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   23/02/2011
Status: Verified

GOAL:

How to create a target database for an existing database.

GOAL:

How to create a target database in Replication 2.0A.

GOAL:

Fathom Replication 3.0A Setup example.

GOAL:

Fathom Replication 3.0A creating a target database example.

GOAL:

How to create a target database in Replication 3.0A.

FACT(s) (Environment):

OpenEdge 10.x
OpenEdge Replication 10.x
Fathom Replication 1.0A
Fathom Replication 2.0A
Fathom Replication 3.0A

FIX:

Steps to enable Site Replication on a database that is already running with After Imaging enabled.



CAUTION: These procedures should be tested using the sports2000 database prior to doing this with a production database.

Sample Locations for source and target databases.

Source. . D:\Apps\Replication\Origin
Target. . E:\Apps\Replication\Destion

1. Shut down live database.
Proshut <dbname> -by

2. Backup all database files including bi and after imaging files.

3. Copy the following file to the source DB directory:

%DLC%\properties\source.repl.properties
Rename this file changing "source" to match the name of the database.

[server]
control-agents=agent1
database=source
transition=manual
transition-timeout=600
defer-agent-startup=900 ( This parameter is not available or supported in Replication 1.0A or 2.0A )

[control-agent.agent1]
name=agent1
database=target
host=localhost
port=4501
maximum-message=32
connect-timeout=120
replication-method=async
critical=0

4. Copy the following file to the target DB directory:

%DLC%\properties\target.repl.properties
Rename this file changing the database name to match the "target" DB name.



[agent]
name=agent1
database=target
listener-minport=4387
listener-maxport=4500

5. Set the environmental variables (not required in 3.0A and newer):

DSRHOME= installation directory FathomR.
PROCFG= %DLC%\progress.cfg

6. Enable Site Replication on source da