IBM DB2 for Linux, UNIX, and Windows as Primary Data Server

Learn about the primary database issues and considerations specific to the DB2 UDB server on a UNIX, Windows, and Linux platform in a Sybase replication system.

• Replication Agent for UDB
  As a primary data server, DB2 UDB interacts with Replication Agent. An instance of the Replication Agent configured for the DB2 UDB is referred to as a Replication Agent for UDB.
• DB2 UDB System Management
  The Replication Agent provides a number of commands that return metadata information about the primary database (database names, table names, procedure names, column names, and so on).
• Replication Manager Limitations
  The Replication Manager plug-in cannot start, but can stop a Replication Agent instance in a primary DB2 UDB data server.
• Replication Intrusions and Impacts on the DB2 UDB
  The performance and operation of the DB2 UDB primary data servers in a Sybase replication system may be affected by the transaction log.
• DB2 UDB Primary Database Permissions and Limitations
  The Replication Agent for UDB requires an DB2 UDB login that has permission to access data and create new objects in the primary database.
• Primary Data Server Connectivity
  Replication Agent for UDB requires some tasks to perform to connect to a primary DB2 data server.
• Replication Server and RSSD Connectivity
  Replication Agent uses TCP/IP and the Sybase JDBC driver (jConnect for JDBC, which is included in Replication Agent installation) to communicate with other Sybase servers. The Replication Agent does not rely on the Sybase interfaces file for connectivity information.
• Replication Agent Objects
  When you initialize Replication Agent using pdb_xlog init, it creates objects that support replication in the primary database.
• DB2 UDB Primary Database Configuration
  Consider additional issues specific to heterogeneous replication.
• Replication Definitions for Primary Tables in DB2 UDB
  The Replication Agent use_rssd configuration parameter controls whether the Replication Agent sends Log Transfer Language (LTL) that contains only the columns specified in a replication definition, or all of the columns in the primary table.
• DB2 UDB Primary Datatype Translation
  The Replication Agent allows you to control how it sends the DB2 UDB DATE, TIME, and TIMESTAMP column values to the Replication Server.