Release 10.1B: Progress Fathom Replication
User Guide


Setting up the source database (offline backup)

This section describes 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 script every time you open a command-line window or shell, and ensure that you have $DLC, $PROMSGS, $DSRHOME, and $PROCFG environment variables set correctly. For more information about these variables, see OpenEdge Getting Started: Installation and Configuration .
  2. Shut down the source database.
  3. Back up the source database.
  4. You can use either PROBKUP or os -copy to back up the database. However, keep in mind that if your source database has after-image files and you use os -copy, after-imaging will also be enabled on the target database. After-imaging is not necessary on the target database; however, if it is enabled, the management of the after-image files on the target must be handled separately from the source.

For more information about how to perform these tasks see OpenEdge Data Management: Database Administration . For more information on how to perform these tasks, see OpenEdge Data Management: Database Administration .

Creating a structure file

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

prostrct list source-db-name source-db-name.st 

(Later, you will move the structure file that originates from the source to the target machine.)

Enabling after-imaging

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

To enable AI on your source database:

  1. Add AI areas by entering the following command:
  2. prostrct add source-db-name addai.st 
    

    Where addai.st is the name of your structure file. The 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.

  3. Back up the database, as shown:
  4. probkup source-db-name source-db-name.bak 
    

  5. Turn on AI with the RFUTIL utility, as shown:
  6. rfutil db-name -C aimage begin 
    

    For more information on using the RFUTIL utility, see OpenEdge Database Management: Database Administration .

Enabling the source database for Fathom Replication

Fathom Replication requires that the source database be enabled for Replication before you start it.

To enable the source database, enter the following command:

proutil source-db-name -C enableSiteReplication source 

Performing an incremental backup of the source database

After your database has been enabled as a source database, you must perform an incremental backup.

Enter the following command:

probkup source-db-name target-db-name incremental 

You will use the incremental backup to create the target database. For more information on incremental backups, see OpenEdge Database Management: Database Administration .

Where to go next

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


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