Chapter 4. Peer-to-peer Q replication on z/OS platforms 361
򐂰 “Stop the Q Apply program that is applying data for the Q subscription in
error” affects latency by introducing a delay; however, it permits correction
without having to reload/resynch.
Click Next to specify how the target tables should be loaded in Figure 4-59.
Figure 4-59 How should target tables be loaded
We chose the Manual option for this set of tables, indicating that we would be
responsible for synchronizing the data in the target table with that of the source
tables and sending a LOADDONE signal to the source Q Capture program when
the load was completed. We selected the Start all Q subscriptions
automatically option target tables. We also selected DT11 to be the source for
the initial load, as shown in Figure 4-59.
Click Next to review the subscriptions defined.
362 WebSphere Information Integrator Q Replication: Fast Track Implementation Scenarios
Figure 4-60 Review and complete Q subscriptions
Figure 4-60 is displayed while both z/OS databases are checked for accuracy of
the replication request, and verified that the tables can be replicated. At the end
of this Figure 4-61 is displayed showing the 46 subscriptions—two for each of the
23 tables.
Chapter 4. Peer-to-peer Q replication on z/OS platforms 363
Figure 4-61 Review and complete Q subscriptions
Figure 4-61 shows 46 subscriptions in all—two for each of the 23 tables on each
server. Click Next to complete the definition of the subscriptions and view the
summary, as shown in Figure 4-62.
364 WebSphere Information Integrator Q Replication: Fast Track Implementation Scenarios
Figure 4-62 Create Q Subscriptions - Summary
Review the summary in Figure 4-62 and click Finish to generate the scripts for
creating the various objects on the two servers, as shown in Figure 4-63.
Click the Back button to go back and correct any errors.
Chapter 4. Peer-to-peer Q replication on z/OS platforms 365
Figure 4-63 Messages and SQL Scripts
Click Close to decide whether to run the scripts right away or save it for later
execution, as shown in Figure 4-64.

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.