Progress Fathom Replication
User’s Guide

> ## Target database access

> The type of access allowed on the target database depends on which Fathom Replication product you have installed and the activity being performed by the Replication agent.

> If the Fathom Replication Plus product is installed, the target database can be accessed for read-only use by any process. If updates are attempted, an error will occur.

> If the Fathom Replication Plus product is not installed, access to the target database is limited to the following system-level tools shown in Table 2–2.

> Limited logins are allowed immediately after the agent completes its startup. Normal logins that allow the access listed in Table 2–2 are allowed after synchronization completes.

> Table 2–2: Standard system-level access to target database
> Tool | Description
> --- | ---
> Shut down | `PROSHUT` command to shut down the database.
> Monitor | `PROMON` utility that displays database information.
> AIW | A background process that writes AI buffers to disk soon after they are filled.
> BIW | A background process that continually writes filled BI buffers to disk.
> WDOG | The watchdog cleans up after improperly terminated processes.
> Replication agent | Receives information from the Replication server and updates the target database.
> Replication Utility DSRUTIL | Allows you to perform specific Replication agent and target database commands.
> Fathom database agent | Provides information to Fathom Management about the status of the database.

> If the Fathom Replication agent is transitioning the target database to a normal Progress database, critical system-level commands are allowed to access the database, as shown in Table 2–3.

> Table 2–3: System-level access to target database during transition
> System-level activity | Description
> --- | ---
> Shut down | `PROSHUT` command to shut down the database.
> Monitor | `PROMON` that displays database information.
> WDOG | The watchdog cleans up after improperly terminated processes.

> When transition is complete and the target database becomes a normal Progress database, all traditional database activity is allowed.

> Connecting a client to a target database in read-only mode (`-RO`) is never allowed. If the target database transitions to a normal Progress database, read-only mode is allowed.

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