Replication Server actions depend on the values you set for memory control parameters.
Examples that show Replication Server applying a transaction with 100,000 updates on two tables. Table1 has 100 columns and requires approximately 4GB of memory, and Table2 has 10 columns requiring approximately one-tenth the memory—400MB.
dsi_cdb_max_size Value (MB) | Table Name | Impact on Replication Processing |
---|---|---|
1024 (default) | Table1 | Prerequisite: Set memory_limit in Replication Server to a value large enough to allow the construction of 1GB net-change databases. Replication Server uses 4 1GB net-change database instances to apply the transaction. |
1024 (default) | Table2 | Prerequisite: Set memory_limit in Replication Server to a value large enough to allow the construction of 400MB net-change databases. Replication Server uses 1 400MB net-change database instance to apply the transaction. |
4096 | Table1 | Prerequisite: Set memory_limit in Replication Server to a value large enough to allow the construction of 4GB net-change databases. Replication Server uses 1 4GB net-change database instance to apply the transaction. |
4096 | Table2 | Prerequisite: Set memory_limit in Replication Server to a value large enough to allow the construction of 400MB net-change databases. Replication Server uses 1 400MB net-change database instance to apply the transaction. |