Figures 1-1 Levels of availability and costs. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1-2 Availability chains. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 2-1 A simple Q replication configuration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 2-2 Specifying how target table is to be loaded for given Q subscription . . . . . 14 2-3 Activating Q subscription via the Replication Center . . . . . . . . . . . . . . . . . 15 2-4 Manual load processing flow in unidirectional Q replication. . . . . . . . . . . . 16 2-5 Ongoing replication flow. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 2-6 Latency statistics collected. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 2-7 Computing latency statistics. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 3-1 Bidirectional replication topology configuration . . . . . . . . . . . . . . . . . . . . . 36 3-2 Tables used in the bidirectional replication scenario . . . . . . . . . . . . . . . . . 37 3-3 Bidirectional replication topology objects overview . . . . . . . . . . . . . . . . . . 40 3-4 Overview of set up steps for the bidirectional replication environment . . . 41 3-5 Data loss and potential sources of conflicts . . . . . . . . . . . . . . . . . . . . . . . . 42 3-6 Bidirectional replication high availability failover and switchback options . 49 3-7 Overview of controlled failover (CF) steps . . . . . . . . . . . . . . . . . . . . . . . . . 51 3-8 Overview of switchback after controlled failover (CF) steps . . . . . . . . . . . 57 3-9 Q Capture latency and end-to-end latency using Replication Center 1/4 . 62 3-10 Q Capture latency and end-to-end latency using Replication Center 2/4 63 3-11 Q Capture latency and end-to-end latency using Replication Center 3/4 63 3-12 Q Capture latency and end-to-end latency using Replication Center 4/4 64 3-13 Viewing exceptions through Replication Center 1/4. . . . . . . . . . . . . . . . . 68 3-14 Viewing exceptions through Replication Center 2/4. . . . . . . . . . . . . . . . . 69 3-15 Viewing exceptions through Replication Center 3/4. . . . . . . . . . . . . . . . . 69 3-16 Viewing exceptions through Replication Center 4/4. . . . . . . . . . . . . . . . . 70 3-17 Overview of uncontrolled failover (UF) steps . . . . . . . . . . . . . . . . . . . . . . 73 3-18 Overview of Option A steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77 3-19 Overview of Option B steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86 3-20 Overview of Option C steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104 3-21 Overview of Option D steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111 4-1 Unidirectional replication topology configuration . . . . . . . . . . . . . . . . . . . 120 4-2 HADR and DB2 Client Reroute synergy . . . . . . . . . . . . . . . . . . . . . . . . . 121 4-3 Overview of steps to set up HADR. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123 4-4 Overview of steps to set up DB2 Client Reroute . . . . . . . . . . . . . . . . . . . 135 4-5 Tables used in the unidirectional replication scenario . . . . . . . . . . . . . . . 145 4-6 Overview of steps to set up the unidirectional scenario . . . . . . . . . . . . . . 145 4-7 Overview of steps to set up the unidirectional replication environment . . 150 4-8 Overview of planned takeover steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157 © Copyright IBM Corp. 2006. All rights reserved. vii