Tuning replication to maximize throughput

To maximize replication throughput, changes must be written to and then fetched from the changed-data (CD) tables quickly and as often as possible.

To maximize replication throughput, SQL Replication must perform both of the following tasks:

Capture changes from the Db2® log or journal and write these changes to the CD tables as quickly and as often as possible.
Fetch the changes from the CD tables and apply them to the target tables as quickly and as often as possible.

When you tune replication for maximum throughput, you must often increase the resource consumption for both the source and target databases. This section assumes that your system and database resource needs are secondary to throughput.

To improve the replication throughput for both the Capture and Apply programs, consider creating a set of dedicated bufferpools for the CD tables and the UOW table to improve the Apply fetch rate and reduce I/O for both the Capture and Apply programs.