Progress Fathom Replication
User’s Guide

> ## Setting up the source database (offline backup)

> This section details some of the tasks you must perform on the source database to prepare to run Fathom Replication. Refer to this section if you are using an offline backup of the source database to create the target database.

> If you are using the deferred agent startup implementation of Fathom Replication and want to create a target database from an online backup of the source database, see the "Setting up the source database (online backup)" section.

> ##### Before you begin

> Before setting up the source database, you must complete the following preliminary tasks:

> 1. Execute your `PROENV` and `DSRENV` scripts every time you open a command-line window or shell, and ensure that you have `$DLC`, `$PROMSGS`, `$DSRHOME`, and `$PROCFG` environment variables set correctly.

> 2. Shut down the source database.

> 3. Back up the source database.

> For more information on how to perform these tasks see the Progress Database Administration Guide and Reference .

> ##### Creating a structure file

> Once you have backed up your source database, you need to build a structure file (.st) with the following command:

>     PROSTRCT list source_db_name source_db_name.st

> The structure file that originates from the source will be moved to the target machine.

> ##### Enabling after-imaging

> To use Fathom Replication, after-imaging (AI) must be enabled on your source database. If AI is already enabled on your machine, skip this section and go to the "Enable the source for Fathom Replication" section.

> To enable AI on your source database:

> 1. Add AI areas by entering the following command:

>     PROSTRCT add source_db_name addai.st

> where `addai.st` is the name of your structure file. This structure file defines AI areas to be added to the database. You might need to build a structure file that contains the AI area specifications.

> 2. Turn on AI with the `RFUTIL` Utility. For more information on using the `RFUTIL` utility, see the Progress Database Administration Guide and Reference .

> ##### Enable the source for Fathom Replication

> Fathom Replication requires that the source database be enabled before starting the database. To enable the source database, enter the following command:

>     PROUTIL source_db_name -C enableSiteReplication source

> ##### Incremental backup of source database

> After your database has been enabled as a source database, you must perform an incremental backup.For more information on incremental backups, see the Progress Database Administration Guide and Reference . You will use the incremental backup to create the target database.

> After you complete the tasks described in this section, go to the "Starting up the target database" section.

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