Basic SQL Replication tutorial: DB2 for Windows

This tutorial helps you gain experience in using the Replication Center and the Capture and Apply programs.

Follow the steps of the tutorial to set up your replication environment, copy changes from a sample SQL Replication source to a target table in a database on DB2® for Windows Enterprise Server Edition (ESE) or Workgroup Server Edition (WSE), and to monitor the activities of the Capture and Apply programs.

  1. Before you begin
    Before you can work through this tutorial, you must set up your system.
  2. Planning the SQL Replication tutorial
    This tutorial is based on assumptions about what you want to replicate and which options you will choose.
  3. Setting up the replication environment for this tutorial
    After planning the replication model, the next steps you complete in this tutorial involve setting up the replication environment.
  4. Operating in a replication environment
    After the replication environment is up and running, changes that you make to the replication source table are replicated to the target table. You can view the status for both the Capture and Apply programs to understand your replication latency and other information about your replication environment.
  5. Monitoring replication
    After the replication environment is up and running, you can monitor the Capture and Apply programs and set up automatic notifications for specific conditions.