Replication Agent for UDB transaction log

NoteThis section describes the schema and details of the Replication Agent transaction log base objects for a primary database that resides in the DB2 Universal Database server. For more general information, see the Sybase Replication Agent Administration Guide.

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.

NoteThe Replication Agent for UDB does not create stored procedures for replication. However, it does create stored procedures that are used for truncation when the pdb_xlog init command is used.

The Replication Agent for UDB creates tables in the primary database for its system information. The Replication Agent system tables are created when the pdb_xlog command is invoked with the create keyword. When you invoke this command, Replication Agent generates a SQL script that is run in the primary database. This script is stored in the create.sql file in the RAX-15_0\inst_name\scripts\xlog directory.

The create.sql script creates Replication Agent transaction log components referred to as the transaction log base objects. The transaction log base objects must be created before any tables can be marked for replication in the primary database.