Linux, UNIX, and Windows database tuning

When you set up a replication environment, be aware that certain DB2® database objects have a significant impact on performance.

Before you focus on tuning replication performance, ensure that your DB2 databases themselves are properly tuned, both for replication and for your application workload. Be sure to tune your source and target databases. When you set up a replication environment, be aware that the following DB2 objects have a significant impact on performance:
  • Database objects
  • Database parameters
  • Database environment variables