Progress Fathom Replication
User’s Guide

> ## Configuring Fathom Replication

> To configure your source database for Fathom Replication, you must configure a replication properties file for both the Fathom Replication server and the Fathom Replication agent.

> ##### Configuring the Fathom Replication server

> The following steps document how to configure your Fathom Replication server.

> To configure the Fathom Replication server for your source database:

> 1. Make a copy of the `source.repl.properties` file located in the `properties` subdirectory of the Fathom Replication installation.

> 2. Place the new file in the same directory as your source database with the name `database`.`repl.properties`, where `database` is the name of your source database.

> 3. To alter the default configuration, this file must be edited. If you are on UNIX, you can use vi, emacs, or your favorite text editor to change the properties file. If you are on a Windows platform, you can use Notepad or the Progress Explorer to change your properties file. For more information on the variables you can configure in the properties file, see the "Fathom Replication properties" section.

> The following is a sample properties file for the Fathom Replication server with one configured agent:

>     # Fathom Replication properties file for a database that will be used
>     #  as a source database for Fathom Replication. This is a single agent
>     #  configuration.
>     [server]
>         control-agents=agent1
>         database=source
>         transition=manual
>         transition-timeout=1200
>     [control-agent.agent1]
>         name=agent1
>         database=your target name
>         host=yourhost
>         port=yourport or service name
>         connect-timeout=120
>         replication-method=async
>         critical=0

> In the previous example, `agent1` in the `control-agents=agent1` of the `[server]` section must match the control agent name specified in the `[control-agent.agent1]` section head.

> The following is a sample properties file for the Fathom Replication server with two configured agents:

>     # Fathom Replication properties file for a database that will be used
>     #  as a source database for Fathom Replication. This is a two agent
>     #  configuration.
>     [server]
>          control-agents=agent1, agent2
>          database=source
>          transition=manual
>          transition-timeout=1200

>     [control-agent.agent1]
>          name=agent1
>          database=your target name
>          host=yourhost
>          port=your port or service name
>          connect-timeout=120
>          replication-method=async
>          critical=0
>     [control-agent.agent2]
>          name=agent2
>          database=your target name
>          host=yourhost
>          port=your port or service name
>          connect-timeout=120
>          replication-method=async
>          critical=0

> In this example, `agent1` in the `control-agents=agent1` of the `[server]` section must match the control agent name specified in the `[control-agent.agent1]` section head. Also, `agent2` in the `control-agents=agent2` of the `[server]` section must match the control agent name specified in the `[control-agent.agent2]` section head. `ALL` is not allowed as an agent name. Each agent must have a unique name.

> ##### Agent rules

> The following rules apply to the Fathom Replication agent:

> - Once a Fathom Replication agent is removed from the properties file, it should not be added again unless the target database is recreated from the source database.

> - Do not rename an Fathom Replication agent after Fathom Replication has been started once.

> - You can add an additional Fathom Replication agent (maximum is two agents) as long as the target databases are created as instructed.

> ##### Configuring the Fathom Replication agent

> Before you start Fathom Replication on your target database you must configure your agent.

> To configure Fathom Replication agent for the target database:

> 1. Make a copy of the `target.repl.properties` file located in the `properties` subdirectory of the Fathom Replication installation.

> 2. Place this new file in the same directory as your target database with the name `database``.repl.properties`, where `database` is the name of your target database.

> 3. To alter the default configuration, the `database``.repl.properties` file must be edited. If you are on UNIX, you can use vi, emacs, or your favorite text editor to change the properties file. If you are on a Windows platform, you can use Notepad or the Progress Explorer to change your properties file. For more information on the variables you can configure in the properties file, see the "Fathom Replication properties" section.

> The following is a sample properties file for the Fathom Replication agent:

>     # This file describes a Replication Agent.
>     [agent]
>          name=agent1     # agent1 must match control agent name from server
>          database=target     # target is the name of your target database
>          listener-minport=1500
>          listener-maxport=4500

Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095