The performance and operation of the DB2 UDB primary data servers in a Sybase replication system might be affected by the transaction log in the following ways:
You must set the LOGARCHMETH1 configuration parameter to LOGRETAIN or DISK:<path>, where <path> is the directory to which the logs are archived (by using the pdb_xlog command). To determine the current LOGARCHMETH1 setting, use the following UDB command:
get db cfg for <db-alias>
Replication requires a before and after image of each row that is changed. When you mark a primary table for replication, the Replication Agent for UDB sets the table’s DATA CAPTURE option to DATA CAPTURE CHANGES. As the number of tables marked for replication increases, so does the space requirement for the DB2 UDB transaction log.
The primary database must have a temporary user system-managed tablespace with a page size of at least 8KB.
