Informix datatype restrictions  Transaction log components

Chapter 2: Replication Agent for Informix

Replication Agent for Informix transaction log

Sybase Replication Agent uses its own proprietary transaction log to capture and record transactions in the primary database for replication. The Replication Agent transaction log consists of a set of shadow tables, stored procedures, and triggers that are created 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_6\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 an Informix database. For more general information about the Replication Agent transaction log, see the Sybase Replication Agent Administration Guide.





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

View this book as PDF