Help Q Replication and Event Publishing

Coexistence support in Version 9.7 Q Replication and Event Publishing

For unidirectional Q subscriptions, the Q Capture and Q Apply programs support full interoperability between Version 9.7, Version 9.5, Version 9.1, and Version 8.2.

The initialization protocol for peer-to-peer and bidirectional replication changed with Version 9.7, so that replication does not pause while all Q subscriptions are being activated. Because of this change, if any of the Q Capture or Q Apply programs in the configuration are migrated to Version 9.7 and you need to add a new Q subscription or activate a disabled Q subscription, all of the Q Capture and Q Apply programs in the configuration must be at Version 9.7. Active Q subscriptions are not affected.

After you install a Version 9.7 Q Replication or Event Publishing program on the system where Q Capture runs, you migrate the Q Capture control tables to Version 9.7. You might need to change the value of the compatibility parameter depending on the version of your Q Apply program or programs.

Important: The compatibility level of the Q Capture server must be lower than or at the same level as the architecture level of the consuming Q Apply program's control tables.

New functions that are introduced in Version 9.7 are not enabled until both the Q Capture and Q Apply control tables are migrated to Version 9.7.

Figure 1 shows relationships between Version 8 and Version 9 replication programs and the effect of the compatibility parameter.

Figure 1. Effect of compatibility parameter on level of messages sent from Q Capture to Q Apply
Effect of the Q Capture compatibility parameter

Other coexistence features for Version 9.7

The following list details other coexistence features of Version 9.7 Q Replication and Event Publishing:

ASNCLP and Replication Center
You can use replication administration tools at the Version 9.7 level to manage Version 9.7, Version 9.5, Version 9.1, and Version 8.2 Q Replication and Event Publishing environments. If your tools are at Version 8, you can use them only to manage Version 8 environments.
Replication Alert Monitor
If you are using a Monitor program from Version 8, you must migrate to a Version 9.5 Monitor to work with Version 9.5 or newer replication and Event Publishing programs. A Monitor program at Version 9.7, Version 9.5, or Version 9.1 can work with Version 9.7, Version 9.5, Version 9.1, or Version 8.2 replication and Event Publishing programs.
Queue formatting program
The Version 9.7 asnqmfmt program can format and display Version 9.7, Version 9.5, Version 9.1, and Version 8.2 messages.
Q Analyzer program
The Version 9.7 asnqanalyze program works with Version 9.7, Version 9.5, Version 9.1, and Version 8.2 Q Replication and Event Publishing control tables.
Table differencing and repair programs
The Version 9.7 asntdiff and asntrep programs work with source and target tables in Version 9.7, Version 9.5, Version 9.1, and Version 8.2 DB2® servers.
Note: None of the utilities supports forward compatibility. For example, a V8.2 Monitor program or V8.2 asnqanalyze program cannot handle V9.7 replication servers.


Send your feedback | Information roadmap | The Q+SQL Replication Forum

Update icon Last updated: 2013-10-25