Replication Agent for UDB transaction log

The Replication Agent for UDB uses the native database transaction log maintained by the DB2 Universal Database server to capture transactions in the primary database for replication. The Replication Agent for UDB also creates tables in the primary database for its system information.

NoteUnlike other implementations of the Sybase Replication Agent, the Replication Agent for UDB does not create stored procedures and triggers in the primary database.

The Replication Agent transaction log is created by invoking the pdb_xlog command with the create keyword. When you invoke this command, Replication Agent generates a SQL script that is run in the primary database. This script (stored in the create.sql file in the rax-12_5\inst_name\scripts\xlog directory) creates the Replication Agent transaction log components referred to as the transaction log base objects. The transaction log base objects must be created before any objects can be marked for replication in the primary database.

NoteThis section describes the schema and details of the Replication Agent transaction log for a primary database that resides in the DB2 Universal Database server. For more general information about the Replication Agent transaction log, see Chapter 3, “Administering Sybase Replication Agent” in this book.