Replication Agent Management

Review the administration and maintenance tasks for Replication Agent for Oracle, Replication Agent for Microsoft SQL Server, and Replication Agent for UDB.

The administration and maintenance tasks for Replication Agent include:

Initializing Replication Agent
Deinitializing Replication Agent
Truncating the transaction log
Backing up Replication Agent objects in the primary database

Replication for Oracle

The Replication Agent for Oracle uses the Oracle LogMiner to capture replicated transactions. The objects it creates in the primary database facilitate stored procedure replication. These database objects require no routine maintenance.

Depending on the configuration, Replication Agent may also access archived transactions logs (default) or may process only online transaction logs. For information about redo log and archive log files, see the Replication Agent Primary Database Guide.

Replication Agent for Microsoft SQL Server

The Replication Agent for Microsoft SQL Server uses the native Microsoft SQL Server log to capture replicated transactions. The objects it creates in the primary database facilitate replication. These database objects require no routine maintenance.

See the Replication Agent Primary Database Guide for information about how to automatically truncate the primary database transaction log.

Replication Agent for UDB

The Replication Agent for UDB uses the native DB2 log to capture replicated transactions. The Replication Agent for UDB creates objects in the primary database to store its system data, but those database objects require no routine maintenance.

Depending on the configuration, Replication Agent may process only online transaction logs (default) or may also access archived transactions logs. For information about online transaction log files, archive transaction log files, and log truncation, see the Replication Agent Primary Database Guide.

Initializing a Replication Agent Instance
Initialize an instance of Replication Agent, and create the objects it needs in the primary database.
Deinitializing a Replication Agent Instance
Deinitialize an instance of Replication Agent, and remove its objects from the primary database.
Transaction Log Truncation
The Replication Agents for Oracle, Microsoft SQL Server, and UDB support both automatic and manual truncation of the transaction log.
Primary Database Backup
The Replication Agent does not support automatically backing up and restoring Replication Agent objects in the primary database.

Parent topic: Administration