Memory Control Parameters and Replication Server Processing

Replication Server actions depend on the values you set for memory control parameters.

Setting dsi_cdb_max_size to Different Values

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.