Figures 1-1 Levels of availability and costs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 1-2 Availability chains . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 2-1 A simple Q replication configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2-2 Specifying how target table is to be loaded for given Q subscription . . . . . . . . . . . . . . 11 2-3 Activating Q subscription via the Replication Center . . . . . . . . . . . . . . . . . . . . . . . . . . 12 2-4 Manual load processing flow in unidirectional Q replication . . . . . . . . . . . . . . . . . . . . . 13 2-5 Ongoing replication flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 2-6 Latency statistics collected . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 2-7 Computing latency statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 3-1 Bidirectional replication topology configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 3-2 Tables used in the bidirectional replication scenario . . . . . . . . . . . . . . . . . . . . . . . . . . 30 3-3 Bidirectional replication topology objects overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 3-4 Overview of setup steps for the bidirectional replication environment . . . . . . . . . . . . . 34 3-5 Data loss and potential sources of conflicts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 3-6 Bidirectional replication high availability failover and switchback options . . . . . . . . . . . 40 3-7 Overview of controlled failover (CF) steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 3-8 Verify transmit queue on the primary server SC53 is fully consumed 1/3. . . . . . . . . . . 44 3-9 Verify transmit queue on the primary server SC53 is fully consumed 2/3. . . . . . . . . . . 44 3-10 Verify transmit queue on the primary server SC53 is fully consumed 3/3. . . . . . . . . . 45 3-11 Overview of switchback after controlled failover (CF) steps . . . . . . . . . . . . . . . . . . . . 47 3-12 Q Capture latency and end-to-end latency using Replication Center 1/4 . . . . . . . . . . 53 3-13 Q Capture latency and end-to-end latency using Replication Center 2/4 . . . . . . . . . . 53 3-14 Q Capture latency and end-to-end latency using Replication Center 3/4 . . . . . . . . . . 54 3-15 Q Capture latency and end-to-end latency using Replication Center 4/4 . . . . . . . . . . 55 3-16 Q Capture latency and end-to-end latency using Live Monitor 2/2 . . . . . . . . . . . . . . . 56 3-17 Verify transmit queue on the secondary server SC59 is fully consumed . . . . . . . . . . 57 3-18 Verify receive queue on the primary server SC53 is fully consumed . . . . . . . . . . . . . 58 3-19 Viewing exceptions through Replication Center 1/4 . . . . . . . . . . . . . . . . . . . . . . . . . . 59 3-20 Viewing exceptions through Replication Center 2/4 . . . . . . . . . . . . . . . . . . . . . . . . . . 59 3-21 Viewing exceptions through Replication Center 3/4 . . . . . . . . . . . . . . . . . . . . . . . . . . 60 3-22 Viewing exceptions through Replication Center 4/4 . . . . . . . . . . . . . . . . . . . . . . . . . . 60 3-23 Overview of uncontrolled failover (UF) steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62 3-24 Verify receive queue on the secondary server SC59 is fully consumed 1/3 . . . . . . . . 64 3-25 Verify receive queue on the secondary server SC59 is fully consumed 2/3 . . . . . . . . 64 3-26 Verify receive queue on the secondary server SC59 is fully consumed 3/3 . . . . . . . . 65 3-27 Overview of Option A steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 3-28 Overview of Option B steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 3-29 Overview of Option C steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86 3-30 Overview of Option D steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97 4-1 Unidirectional replication topology configuration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105 4-2 Tables used in the unidirectional replication scenario . . . . . . . . . . . . . . . . . . . . . . . . 106 4-3 Unidirectional replication topology objects overview. . . . . . . . . . . . . . . . . . . . . . . . . . 108 4-4 Set up of the WebSphere shared queues unidirectional environment . . . . . . . . . . . . 109 4-5 Failover operations with no inflight automatic load in progress test case with shared queues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136 4-6 Stop channel from the secondary server SC59 to the primary server SC53 1/4 . . . . 140 4-7 Stop channel from the secondary server SC59 to the primary server SC53 2/4 . . . . 140 4-8 Stop channel from the secondary server SC59 to the primary server SC53 3/4 . . . . 141 © Copyright IBM Corp. 2006. All rights reserved. vii