Replication Agent Functionality

Replication Agent supports transaction replication from a primary database through Replication Server.

Note: See the Replication Server Options Release Bulletin for information about the specific versions of Oracle, Microsoft SQL Server, and IBM DB2 that Replication Agent supports.

Replication Agent runs as a standalone application, independent of the primary data server, the primary Replication Server, and any other replication system components.

Replication Agents can reside on the same host machine as the primary database or any other replication system component, or they can reside on a machine separate from any other replication system components that has network access to the primary database. Replication Agents must execute on a machine that has access to the transaction logs for the primary database. For Replication Agent for UDB, this is accomplished using the IBM DB2 client.

For Replication Agent for Oracle, this is accomplished using Oracle Log Miner or Oracle XStream. Replication Agent for Microsoft reads the Microsoft SQL Server transaction log file.

You can completely configure, manage, and monitor a Replication Agent instance using any Open Client™ application that is capable of communicating with the Tabular Data Stream™ (TDS) protocol (such as isql).