76 WebSphere Information Integrator Q Replication: Fast Track Implementation Scenarios
alternative and does not require additional columns and triggers to be defined
on existing data.
򐂰 Ithaca’s requirement for a controlled switchback to the primary server from
the secondary server is handled well by a bidirectional replication topology.
3.4 Environment configuration
Figure 3-1 shows the configuration used in the Ithaca bidirectional replication
topology.
Figure 3-1 Bidirectional replication topology configuration for Ithaca
We installed a set of 23 tables with referential integrity constraints defined
between some of them. Full details of these tables are documented in
Appendix F, “Tables used in Q replication scenarios” on page 781.
3.5 Step-by-step setup
In this section we document the step-by-step setup of the bidirectional replication
topology in our fictitious company. Figure 3-2 lists the main steps involved in
setting up the environment. Each of these steps is described in detail in the
following subsections.
Secondary Server WTSC53
Hostname WTSC53.pok.ibm.com
IP Address 9.12.6.77
z/OS R1.5
Model 2064-1C7
DB2 for z/OS V8 NFM,
2 member datashare group
DB2 II V8 R2
WebSphere MQ V5.3.1
Primary Server STLABD1
Hostname Stlabd1.svl.ibm.com
IP Address 9.30.132.94
z/OS R1.5
Model 2064-216
DB2 for z/OS V8 NFM,
2 member datashare group
DB2 II V8 R2
WebSphere MQ V5.3.1
N
E
T
W
O
R
K
I
N
T
E
R
N
A
L

Get WebSphere Information Integrator Q Replication: Fast Track Implementation Scenarios now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.