DB2 Universal Database datatype restrictions  Transaction log components

Chapter 1: Replication Agent for UDB

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.

NoteThe Replication Agent for UDB does not create stored procedures and triggers in the primary database.

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-12_6\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.

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. See the Sybase Replication Agent Administration Guide for more general information about the Replication Agent transaction log.





Copyright © 2005. Sybase Inc. All rights reserved. Transaction log components

View this book as PDF